If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need help comparing 2 columns of number to find unique numbers
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. |
#2
|
|||
|
|||
Need help comparing 2 columns of number to find unique numbers
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. |
#3
|
|||
|
|||
Need help comparing 2 columns of number to find unique numbers
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! |
#4
|
|||
|
|||
Need help comparing 2 columns of number to find unique numbers
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. |
Thread Tools | |
Display Modes | |
|
|