highlight duplicate rows with fixed range

    Re: highlight duplicate rows with fixed range


    Quote

    u have given me the code of a complete row 1


    That workbook only had 4 columns (B to E) to create the primary key from. That code won't work on the file in this thread as there are 8,996 columns (A to MHZ) to join to make a primary out of which is simply just too much for Excel to handle hence you get an out of memory error message. Like I said there is nothing I can suggest.


    Hope that makes sense and like I said good luck with it.

    Re: highlight duplicate rows with fixed range


    highlight duplicates and autofilter by colour
    My data
    1 2
    1 4
    2 5
    3 7
    1 2
    In this 1 is a duplicate in coloumn A and 2 is a duplicate in coloumn B so highlight the same and after that autofilter it by colour only this much process i need My data is big so use As long in the code can it be possible

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login