N
nirod
=countif will highlight only unique records; however, I need one record of
each set of duplicates highlighted.
each set of duplicates highlighted.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
jenn
wondering why you need a color. I find pivot tables very useful when looking
for a duplicate. Drag names(or etc.) to the left and then drag names to the
Data and each duplicate will show as more than 1 count and then just filter
for Greater than 1...
for a duplicate. Drag names(or etc.) to the left and then drag names to the
Data and each duplicate will show as more than 1 count and then just filter
for Greater than 1...
B
Bob Phillips
Use conditional formatting with a formula of
=COUNTIF($A$1:A1,A1)>1
Select all the cells first, assuming A1 as first, and apply the CF.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
=COUNTIF($A$1:A1,A1)>1
Select all the cells first, assuming A1 as first, and apply the CF.
--
HTH
Bob Phillips
(replace xxxx in the email address with gmail if mailing direct)
H
Hile
How do I filter for >x in a pivot?
--
Hile
--
Hile
jenn said:wondering why you need a color. I find pivot tables very useful when looking
for a duplicate. Drag names(or etc.) to the left and then drag names to the
Data and each duplicate will show as more than 1 count and then just filter
for Greater than 1...