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

I think I need somemore information on this. I don't understand your question.
--
Cheers,
Ryan


"Rob" wrote:

> 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

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" wrote:

> I think I need somemore information on this. I don't understand your question.
> --
> Cheers,
> Ryan
>
>
> "Rob" wrote:
>
> > 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

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!
--
Cheers,
Ryan


"Rob" wrote:

> 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" wrote:
>
> > I think I need somemore information on this. I don't understand your question.
> > --
> > Cheers,
> > Ryan
> >
> >
> > "Rob" wrote:
> >
> > > 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

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" wrote:

> 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

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

"cush" wrote:

> 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" wrote:
>
> > 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