Mark duplicate Rows in excel 07 [Closed]

Report
Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
-
 Dy -
Hello all

I am looking for a macro that can help me mark duplicate rows in excel
eg

col A col B col C Result of macro
1 a m
2 b n
3 c s
1 a d
2 f e
3 g r
1 a m Duplicate

Regards
Ujwal

4 replies

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
google search would have given you your solution. see this we bpage

https://www.ozgrid.com/Excel/highlight-duplicates.htm
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
1
No its not the same... if you see the example i have given ... the macro needs to compare the entire row... combination of all the columns ie ir col a = 1, col b=2, clo c = 3.. only when this entire combination occurs again it should highlight not based on only one column...
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
1862
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
July 30, 2015
797
the web page has to be only applied
in your case in D1 type the formula
=A1&B1&C1
copy D1 down

highlight D1 to D7
click format=conditional format
on the left hand(condition 1) arrow choose
the formula is
on the next small window type this formula
=COUNTIF($D$1:$D$100,D1)>1
click "format" in the right middle
choose pattern on the top

choose any color
click ok
click ok

the D1 and D7 will be colored (e.g. red)

1 a m 1am this will be red
2 b n 2bn
3 c s 3cs
1 a d 1ad
2 f e 2fe
3 g r 3gr
1 a m 1am this will be red
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Use the Remove Duplicate Function in Excel. First select the table you wanna clean including headings, press (Remove Duplicates), choose the three columns (duplication criteria) and then OK. You are done.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!