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
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
Re: highlight duplicate rows with fixed range
K
My data
A G C
P L M
A G C
S T E
A G C
P L M
Here A G C & P L M shoul be highlighted
I want to know which type of cpu is best for excel for large files for speed process
My data
1 A B
A F V G
1 A B
I need a formula that can find a duplicate row or let me know that there is a duplicate row here 1 and 3 is same
Re: highlight duplicate rows with fixed range
U have any other trick to find out duplicates in a row
Re: highlight duplicate rows with fixed range
Bro u have given me the code of a complete row 1 month back but when i am using that code it shows error 7 out of memory so that y i am looking for highlight duplicates row with fixed range my question is simple when u join the complete row into one row so u can join A to MHZ coloumn
Re: highlight duplicate rows with fixed range
I thought that i just require a code and i will change the range from ur given code but that is not happened so kindly look into this attachment and solve this problem and dont compare complete row means only B to F range compare with other row
Re: highlight duplicate rows with fixed range
No problem its ok but tomorrow solve this problem
Re: highlight duplicate rows with fixed range
See the attachment
Re: highlight duplicate rows with fixed range
Code is working but it is highlighting non duplicates also
Re: highlight duplicate rows with fixed range
Sorry bro thnx
Re: highlight duplicate rows with fixed range
I am getting run time error 438 from this vba code
Re: highlight duplicate rows with fixed range
K thnx
Re: highlight duplicate rows with fixed range
just let me know which type of cpu u used for excel
Re: highlight duplicate rows with fixed range
Trebror can u let me know which type of cpu is best for excel for large files
Re: highlight duplicate rows with fixed range
Thnx trebror
Each and every details is mentioned in the attachment
Re: highlight duplicate rows
Thnx
