I was kindly given the following formula for checking duplicate entries in a
spreadsheet, =IF(COUNTIF(Range1, ??)1,TRUE,FALSE)
?? being the first cell in the range to be checked, and I formatted the
duplicates to be highlighted in red.
My problem is that it only highlights 2 or 3 where there's actually 4
duplicates, or highlights none duplicates.
Help! Am I missing something?

Is ?? the cell reference? Shouldn't make any difference, but you omly need

=COUNTIF(Range1, ??)1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Nikki" wrote in message
...
I was kindly given the following formula for checking duplicate entries in
a
spreadsheet, =IF(COUNTIF(Range1, ??)1,TRUE,FALSE)
?? being the first cell in the range to be checked, and I formatted the
duplicates to be highlighted in red.
My problem is that it only highlights 2 or 3 where there's actually 4
duplicates, or highlights none duplicates.
Help! Am I missing something?