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
Dy - Mar 25, 2010 at 08:09 AM
Related:
- Mark duplicate Rows in excel 07
- Mark sheet in excel - Guide
- E with accent mark - Guide
- Insert check mark in word - Guide
- Number to words in excel - Guide
- How to duplicate a google doc - Guide
4 responses
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 18, 2009 at 08:11 PM
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
https://www.ozgrid.com/Excel/highlight-duplicates.htm
ujo
Posts
8
Registration date
Wednesday July 15, 2009
Status
Member
Last seen
September 23, 2009
1
Jul 18, 2009 at 11:56 PM
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...
venkat1926
Posts
1863
Registration date
Sunday June 14, 2009
Status
Contributor
Last seen
August 7, 2021
811
Jul 19, 2009 at 05:50 AM
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
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
