compare column of numbers and notify of duplicates

J

Jeanie

I have a rather long column of numbers that I have to
compare on a weekly basis. Is there a formula that will
automatically notify me of a duplicate number?
 
B

Bernie Deitrick

Jeanie,

Use conditional formatting, with the formula

=COUNTIF(A:A,A1)>1

Select column A first, then set the formatting, and pick a color. It
will highligh duplicate values.

HTH,
Bernie
 

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

Inconsistent formatting of section numbers 0
Duplicate entry in a column/row 14
Finding the proper style field and the numbered paragraph value within the style 0
How To Compare Two Csv Files Mainly Two Columns Containing Time 0
Trying to count based on multiple criteria & cell comparisons 4
Finding Duplicate Rows & Highlighting them 6
Paragraph numbering in Word 1
Comparing text strings 5

Top