Highlighting Duplicate Entries in the same Worksheet

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

Guest

Hi all,

I have two lists of 7 digit numbers that start with 'B' (B1234567) and I
need to highlight which ones appear in both lists.

Should be striaght forward but I cant seem to get it to work. I guess it
should be some for of conditional Formatting.

Thanks in advance

Darran
 
CF with a formula of say

=COUNTIF(A:A,A1)>1

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
ASAP Utilities, which is a free add-in easily found by Googling "ASAP
Utilities," makes this an easy job.

After installing the add-in, highlight the range that includes your lists,
and go to "ASAP Utilities/Information/Count Duplicates in Selection." This
will color the cells that contain duplicate data (regardless of order) and
give you a count of duplicates. Easy as pie.
 

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

Excel Highlighting duplicates 0
error in highlighting duplicate values in excel 1
Highlight only the second instance of a duplicate 1
Highlight a cell that is a duplicate 1
Conditional Highlighting 5
Highlighting Duplicate Entries 5
Show a message if there are some duplicates 1
Descending Numbers 11

Back
Top