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.

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 MVP
http://people.stfx.ca/bliengme

"BP" wrote in message
...
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.

On Jan 5, 3:37*pm, "Bernard Liengme"
wrote:
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

"BP" wrote in message

...



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.- Hide quoted text -

- Show quoted text -

Excellent!! Thank you very much!

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

"BP" wrote in message
...
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.