compare column of numbers and notify of duplicates

  • Thread starter Thread starter Jeanie
  • Start date Start date
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?
 
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
 
Back
Top