Duplicate Values
 

I know how to remove duplicate values using DataFilterAdvanced Filter, is
there a way to see which rows are removed? I need to know which lines were
duplicates.

Thanks

Duplicate Values
 

After further thought, is there a function to find duplicate values and
highlight them? That might be easier.

"Lost in Microbiology" wrote:

I know how to remove duplicate values using DataFilterAdvanced Filter, is
there a way to see which rows are removed? I need to know which lines were
duplicates.

Thanks

Duplicate Values
 

Select the whole list, assume list is A2:A50 and A2 is the active cell, then
do formatconditional formatting, select formula is and use

=COUNTIF($A$2:$A$50,A2)1

click the format button and select either a different font colour or
different pattern, click OK twice


--
Regards,

Peo Sjoblom


"Lost in Microbiology" wrote
in message ...
After further thought, is there a function to find duplicate values and
highlight them? That might be easier.

"Lost in Microbiology" wrote:

I know how to remove duplicate values using DataFilterAdvanced Filter,
is
there a way to see which rows are removed? I need to know which lines
were
duplicates.

Thanks