Hello
I need to compare two columns (ex. A and B) and to highlight the duplicated numbers, the problem is that when I use the duplicate command, it compares also the numbers of the same column.
I upload a sample.
Thank you
Hello
I need to compare two columns (ex. A and B) and to highlight the duplicated numbers, the problem is that when I use the duplicate command, it compares also the numbers of the same column.
I upload a sample.
Thank you
You could use this in L5, copied down:
=IF(COUNTIF($K$5:$K$16,K5)*COUNTIF($M$5:$M$16,K5)>0,"YES","")
and this in N5, copied down:
=IF(COUNTIF($K$5:$K$16,M5)*COUNTIF($M$5:$M$16,M5)>0,"YES","")
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
If coding will do ,Try this:-
Data assumed to be in column"A" and column "C".
Regards MickPlease Login or Register to view this content.
Pl see attached file.
Thank you very much again
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks