Hello All,
I would like to compare few lists of Id's on the same work sheet and would like to have a list which only have unique ids(or in other words Ids common in all lists).
I also like to see the ones that did not have a match.I use 2000.
I would highly appreciate anyone offering me a tip or a formula to do so...
Thanks in advance

[SIZE=2][COLOR=Indigo]