Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Highlighting duplicate cells in a column
I need to highlight duplicate cells in a column (not hide them). Someone
posted this simple solution a few weeks back: "Assuming that A1 is a column heading and your name entries begin in A2, 1. select column A 2. data filter advanced filter check Unique Records Only click ok 3. Alt; (selects visible cells) 4. Data filter show all Step 2 will hide all the duplicates. Step 3 will highlight the remaining unique records. Step 4 will make the entire column A reappear, with Unique Records highlighted (grey) and the duplicates un-highlighted (white)." My problem is Step 4 is not working. None of the cells are highlighted (even though I know I have duplicates in my column). What am I doing wrong? (I know how to highlight duplicates with a formula; but I would like to be able to use this method too.) I'll be grateful for any help. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Highlighting duplicate entries | Excel Worksheet Functions | |||
Highlighting Duplicate Values | Excel Worksheet Functions | |||
highlighting duplicate values | Excel Worksheet Functions | |||
Highlighting blanks via GO TO SPECIAL is not highlighting blank cells - HELP, I'm totally stuck. | Excel Discussion (Misc queries) | |||
Highlighting duplicate values in a column | Excel Discussion (Misc queries) |