21-Dec-08 NEW: Compare 2 lists
They said it couldn't be done, but here it is!
A list comparison example ONLY using advanced Excel formulae
This example shows you how to compare 2 lists of data and to work out a sorted list of:
- What's in both lists
- What's in List 1 and not List 2
- What's in List 2 and not List 1