Does anyone know what function can be used in Excel to compare two lists of items and list out items which appear in one list and not the other ?
What I mean is that I have two lists - master and secondary. The master list contains (say) 10,000 entries and the secondary list contains (say) 7,000. I want to return the 3,000 entries which aren't in the secondary list. The values would be unique single values such as pc00001, pc00002, pc00004, etc with no other associated values or keys.
I'm sure this type of thing must come up realtively often, but I can't work out an easy way to do this ?
z
What I mean is that I have two lists - master and secondary. The master list contains (say) 10,000 entries and the secondary list contains (say) 7,000. I want to return the 3,000 entries which aren't in the secondary list. The values would be unique single values such as pc00001, pc00002, pc00004, etc with no other associated values or keys.
I'm sure this type of thing must come up realtively often, but I can't work out an easy way to do this ?
z