how do I identify and highlight duplicate results in a work sheet?

[Guest]

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.

 

[Franz Verga]

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

 

[Gord Dibben]

Kathy

See Chip Pearson's site for instructions.

http://www.cpearson.com/excel/duplicat.htm#HighlightingDuplicates


Gord Dibben MS Excel MVP

 

[Biff]

http://cpearson.com/excel/duplicat.htm#HighlightingDuplicates

Biff