software

I was kindly given the following formula for checking duplicate entries in a
spreadsheet, =IF(COUNTIF(Range1, ??)gt;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, ??)gt;1

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

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