Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i locate/highlight duplicates ?
I'm using excel 2003. I use large S/S and I would like to be able to locate
duplicates easily. I have found a guide on the internet for creating a conditional format for this purpose but for some reason it doesn't work. Any help would be much appreciated. Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i locate/highlight duplicates ?
Well show us what it is and explain what happens.
-- HTH Bob Phillips (replace somewhere in email address with gmail if mailing direct) "Lizardking" wrote in message ... I'm using excel 2003. I use large S/S and I would like to be able to locate duplicates easily. I have found a guide on the internet for creating a conditional format for this purpose but for some reason it doesn't work. Any help would be much appreciated. Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i locate/highlight duplicates ?
See:
http://www.cpearson.com/excel/duplic...tingDuplicates -- Gary's Student "Lizardking" wrote: I'm using excel 2003. I use large S/S and I would like to be able to locate duplicates easily. I have found a guide on the internet for creating a conditional format for this purpose but for some reason it doesn't work. Any help would be much appreciated. Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do i locate/highlight duplicates ?
"Lizardking" wrote: I'm using excel 2003. I use large S/S and I would like to be able to locate duplicates easily. I have found a guide on the internet for creating a conditional format for this purpose but for some reason it doesn't work. Any help would be much appreciated. Thanks Assuming the column A is the First column you wanna highlight items. Select the column. Then goto your conditional formatting. Change the Cell Value is to Formula is and type in the following =IF(COUNTIF($A:$A, A1)1,TRUE,FALSE) Then select the format buttom then Pattern and select your color. then ok and Bingo you got the Duplicated Values highlighted :-P Hope this helps you out... just change the A to the letter of the column your working with... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Checking for duplicates - think this is simple | Excel Discussion (Misc queries) | |||
i need to find duplicates! ASAP | Excel Worksheet Functions | |||
Collapse rows with duplicates | Excel Worksheet Functions | |||
How to indentify duplicates in a "Self Populating" field? | Excel Discussion (Misc queries) | |||
Finding Duplicates | Excel Worksheet Functions |