Comparing Lists

C

Constantly Amazed

Hi

I have frequently used an array formula to compare to lists and to tag
entries that appear on both lists which I originally got from Chip Pearsons
site. The formula is =IF(COUUNTIF($A$1:$A$10,B1)>0,"On Other List","").
However, I have now been asked to compare two lists and only tag entries
which match on two counts. For example instead of simply comparing if
identical invoice numbers occur in two lists tag entries where identical
invoice numbers occur and the value is identical in both cases.

Thanks

G
 

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

Comparing two lists 0
comparing and isolating duplicates in two columns 0
comparing two worksheets 1
multiple dependent drop down lists 6
Possible match and index formula needed please 0
Compare two lists 2
Combining two separate lists and creating new values 5
XL2000 CF and Comparing Lists 6

Top