Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting duplicates
I want to write a formula that highlights duplicate cells within a
column. I know that I can use conditional formatting with a named range using COUNTIF. I continually paste data into this column, however, and find using a named range to be difficult. Any suggestions on using an actual cell range, e.g., A1:A500? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting duplicates
=COUNTIF($A$1:$A$500,A1)1
-- HTH Bob Phillips (remove nothere from email address if mailing direct) "alex" wrote in message oups.com... I want to write a formula that highlights duplicate cells within a column. I know that I can use conditional formatting with a named range using COUNTIF. I continually paste data into this column, however, and find using a named range to be difficult. Any suggestions on using an actual cell range, e.g., A1:A500? |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
highlighting duplicates
thanks bob. it worked. i thought i tried this formula; i guess not
exactly! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Cells in Excel will not stop highlighting | Excel Discussion (Misc queries) | |||
Duplicates | Excel Discussion (Misc queries) | |||
Duplicates | Excel Discussion (Misc queries) | |||
Help with Highlighting all duplicates in a row | Excel Discussion (Misc queries) | |||
Finding Duplicates | Excel Worksheet Functions |