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


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

Advertisements

Ad

Advertisements

A

akac00l

Thanks Frank,

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

Am most grateful.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Selecting the last figure in a row 6
Highlighting Rows 1
Row highlight?? 5
Highlighting Row 2
Highlight row ? 4
Highlighting Rows 2
Can't figure this one out? 1
Checking for Dupes 4

Top