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.

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

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.

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.