COUNTIF suggested by John via Chip Pearson's site is better
for finding duplicates than VLOOKUP, but use of AutoFilter will
get you the second part -- a list of uninformed people who didn't
get on the do not call list.
Wonder how misspelling of VLOOKUP got through my spelling
check anyway.
|