Comparing ranges

I

ibeetb

I would like to compare Range A and Range B and then be able to identify or
write out the items in A that re NOT in B.
Keep in mind,, that range B has unique items but Range A had several
instances of the same name....i.e. non-unique items. I have done this
successfully via Array formulas in the wrksht, but it takes too long. Any
suggestions?
 

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 Worksheet ranges 3
Project Online Timesheets Actuals Mismatches - data not publishing to projects 0
Cell referencing 1
referencing a range in Sumproduct function 6
Formula for Range area within VLookup? 3
Creating a Master List from sub-lists 4
Using cell reference with logical operator in DGET expression 1
Finding a single word match in a text string and assigning a code 8

Top