Conditional Formatting error
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? |
Conditional Formatting error
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? |
All times are GMT +1. The time now is 09:32 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com