Need help comparing 2 columns of number to find unique numbers

[BP]

I have 2 columns of numbers. The first column is a list of unique IDs
(221 IDs) that have signed up for a training program. The second
column is the full list of people who are assigned to course (360
IDs). I need a third column to display only the IDs that do not show
up in the first column.

Any help would be appreciated.

 

[Bernard Liengme]

Column A has the 221 ID's; Column B has the 360 IDs
In C1 enter =IF(COUNTIF(A:A,B1),"",B1)
Copy this down the column by double clicking C1's fill handle (small solid
square in its lower right corner)
ID's that are in B but not in A are displayed in C
Not happy with the blanks? Use Copy followed by Paste Special -> Values to
convert formulas to values and sort column C
best wishes

 

[BP]

Column A has the 221 ID's; Column B has the 360 IDs
In C1 enter =IF(COUNTIF(A:A,B1),"",B1)
Copy this down the column by double clicking C1's fill handle (small solid
square in its lower right corner)
ID's that are in B but not in A are displayed in C
Not happy with the blanks? Use Copy followed by Paste Special -> Values to
convert formulas to values and sort column C
best wishes
--
Bernard Liengme
Microsoft Excel MVPhttp://people.stfx.ca/bliengme







- Show quoted text -

Excellent!! Thank you very much!

 

[Ashish Mathur]

Hi,

First of all kindly put headers for the both the columns. In a blank cell
(say E17), type Criteria and in cell E18, type =COUNTIF($E$6:$E$13,H6)=0.
H6 is the cell reference of the first ID which has signed up for the
training program. E6:E13 has the list of unique ID's. Now click on any
blank cell and go to Data > Filter > Advanced Filter > Copy to another
location. In the list box, select H5:H15 (please note that H5 is the header
row). In the criteria range, select E17:E18. In the copy box, select any
one blank cell. Now click on OK

--
Regards,

Ashish Mathur
Microsoft Excel MVP
www.ashishmathur.com