Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I identify and highlight duplicate results in a work sheet?
I have pulled information into a spread sheet, from various sources. I need
to identify duplicates and hightlight. I have tried conditional formating per Excel Help . . .but can't get it to work. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I identify and highlight duplicate results in a work sheet?
Kathy wrote:
I have pulled information into a spread sheet, from various sources. I need to identify duplicates and hightlight. I have tried conditional formating per Excel Help . . .but can't get it to work. You can use the COUNTIF function: =COUNTIF(your_range,first_cell_of_your_range)1 and copy down along the column. You will have as result TRUE for duplicates and FALSE for not duplicates. -- Hope I helped you. Thanks in advance for your feedback. Ciao Franz Verga from Italy |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I identify and highlight duplicate results in a work sheet?
Kathy
See Chip Pearson's site for instructions. http://www.cpearson.com/excel/duplic...tingDuplicates Gord Dibben MS Excel MVP On Mon, 26 Jun 2006 14:56:02 -0700, Kathy <Kathy @discussions.microsoft.com wrote: I have pulled information into a spread sheet, from various sources. I need to identify duplicates and hightlight. I have tried conditional formating per Excel Help . . .but can't get it to work. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
how do I identify and highlight duplicate results in a work sheet?
http://cpearson.com/excel/duplicat.h...tingDuplicates
Biff "Kathy" <Kathy @discussions.microsoft.com wrote in message ... I have pulled information into a spread sheet, from various sources. I need to identify duplicates and hightlight. I have tried conditional formating per Excel Help . . .but can't get it to work. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Identify Updated Results | Excel Discussion (Misc queries) | |||
Identify repeated cell entries in multiple sheet workbook as you . | Excel Discussion (Misc queries) |