Exception list
Hi,
Suppose List A is in A1:A100 and List B is in D1:D10, assume titles on row 1.
1. In the first cell of a blank column, say B2 enter the following formula:
=COUNTIF($D$2:$D$100,A2) and copy it down
2. Select B1:B100 and choose Data, Filter, AutoFilter
3. From the auto filter drop down pick 0.
4. Highlight the entries in column A and copy and paste them whereever you
want your Exception List.
--
If this helps, please click the Yes button
Cheers,
Shane Devenshire
"Gene Straub" wrote:
I have 2 lists of names, List A and B. I want to create a list of the names
in list A that do not appear in List B. How can this be done?
Gene
|