Duplicate Values

  • Thread starter Lost in Microbiology
  • Start date
L

Lost in Microbiology

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

Thanks
 
L

Lost in Microbiology

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

Peo Sjoblom

Select the whole list, assume list is A2:A50 and A2 is the active cell, then
do format>conditional 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
 
Top