Need to color 1 record of each set of Duplicate Records

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

=countif will highlight only unique records; however, I need one record of
each set of duplicates highlighted.
 
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...
 
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)
 
How do I filter for >x in a pivot?
--
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...
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Compare two datasets and extract unique records from each 3
Removing duplicate records based off of date 3
How to delete all duplicate records - without keeping one of them 5
help...finding duplicates 3
Finding and Isolating Duplicates 4
Find Duplicates in a Schedule (Two fields: Time and ApplicantID) 1
i need to find duplicates! ASAP 4
Find Duplicate in a Row 8

Back
Top