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

[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.

 

[Frank Kabel]

Hi

have a look at
http://www.cpearson.com/excel/duplicat.htm

HTH
Frank

 

[akac00l]

Thanks Frank,

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

Am most grateful.