How do I check for duplicate values in a range of cells?

How do you want to find out? You could use a helper column and use
=COUNTIF(A$1:A$100,A1)1
And copy down, anywhere is says true you have a duplicate.
Or, you could conditionally format (format, conditional format) the first
cell using the same formula, and have the cell highlight in red if its a
duplicate. Then just copy the formatting to the other cells in your range.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Donna" wrote:

How do I check for duplicate values in a range of cells?

Hi Donna,

You could insert a column beside the data and use the following formula. It
will insert the number of similar entries if more than one or blank if only
one.
=IF(COUNTIF($A$1:$A$19,A1)1,COUNTIF($A$1:$A$19,A1 ),"")

alternatively you could use conditional format and set the interior (fill)
color and use the following formula for the condition.

=COUNTIF($A$1:$A$19,A1)1



--
Regards,

OssieMac


"Donna" wrote:

How do I check for duplicate values in a range of cells?