how to check one row of figures against a second row of figures and highlight dupes

  • Thread starter Thread starter akac00l
  • Start date Start date
A

akac00l

Hi all,

first post so thanks for any and all help.

I want to get Excel to check one row of figures against a second row of
figures and get it to highlight any duplicates, it doesn't have to
highlight the actual cells it can show up underneath the 2nd row simply
saying duplicate or something. I've tried a few things with the IF and
vlookup functions but without much look.

Thanks.
 
Thanks Frank,

Thats exactly what I needed, right under "Extracting Values Common To
Two Lists"

Am most grateful.
 
Back
Top