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.


---
Message posted from http://www.ExcelForum.com/

Hi

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

HTH
Frank

> 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.
>
>
> ---
> Message posted from http://www.ExcelForum.com/

Thanks Frank,

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

Am most grateful.


---
Message posted from http://www.ExcelForum.com/