Mark duplicate Rows in excel 07

Closed
ujo
Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
- Jul 18, 2009 at 09:44 AM
 Dy - Mar 25, 2010 at 08:09 AM
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

venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jul 18, 2009 at 08:11 PM
google search would have given you your solution. see this we bpage

https://www.ozgrid.com/Excel/highlight-duplicates.htm
1
ujo
Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
1
Jul 18, 2009 at 11:56 PM
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
venkat1926
Posts
1864
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
805
Jul 19, 2009 at 05:50 AM
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
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.
-2