Comparing data in columns for Non-Matches

[Rob]

Hi All,

I need to comapare two columns and have the numbers that don't appear in
both columns show in a third column. Excel is not my strong point so any help
or suggestions is much appreciated.

Rob

Example
A B C
1 5 5
2 20
5 3 3
3 7

 

[RyanH]

I think I need somemore information on this. I don't understand your question.

 

[Rob]

Hi RyanH
I have two columns of information. One is all the employee numbers sent a
survey the other is all the employees that responded to the survey. What i
need is a third column of all those that did not respond.

Suggestions?
Rob

 

[RyanH]

Let me make sure I have this straight. Col. A contains employee ID numbers
that were set a survey, Col. B contains the employee ID numbers that have
responded and Col. C you want to contain the employee ID numbers that have
NOT responded. If this is correct, put this in formula in each row in Col. C:

=IF(B2="",A2,"")

I hope this helps!

 

[cush]

If I understand your question:

Assuming you have all Employee IDs in Col A,
and assuming there are 100 Employees,
and assuming that Col B contains a subset of these IDs that have turned
in the survey, the following formula entered in cell C1 and copied down to
C100
will return a list in Col C of IDs that have NOT turned in the survey.

=IF(COUNTIF($A$1:$B$100,A1)=1,A1,"")

 

[Rob]

Thank You so much Cush and RyanH,

The spread sheet is now working. Now i have the listing of all that did not
complete the survey.
Rob