From: Donna on

I am using this formula to compare 2 list to see which numbers are not
included in both column A and Col C. The formula I am using below pulls out
the ones that i do have a match . Is there another function that I could
use that would only pull out the ones that there is not a match?

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
Thanks
From: Bob Phillips on
Uh

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),A1,"")


--

HTH

Bob

"Donna" <donna(a)yahoo.com> wrote in message
news:BE688A2B-3D42-45A0-AA3F-B65034C685E1(a)microsoft.com...
>
> I am using this formula to compare 2 list to see which numbers are not
> included in both column A and Col C. The formula I am using below pulls
> out
> the ones that i do have a match . Is there another function that I
> could
> use that would only pull out the ones that there is not a match?
>
> =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
> Thanks


From: Gary''s Student on
Swap them:

=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),A1,"")
--
Gary''s Student - gsnu201001


"Donna" wrote:

>
> I am using this formula to compare 2 list to see which numbers are not
> included in both column A and Col C. The formula I am using below pulls out
> the ones that i do have a match . Is there another function that I could
> use that would only pull out the ones that there is not a match?
>
> =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
> Thanks
From: T. Valko on
Another one...

=IF(COUNTIF(C$1:C$5,A1),"",A1)

--
Biff
Microsoft Excel MVP


"Donna" <donna(a)yahoo.com> wrote in message
news:BE688A2B-3D42-45A0-AA3F-B65034C685E1(a)microsoft.com...
>
> I am using this formula to compare 2 list to see which numbers are not
> included in both column A and Col C. The formula I am using below pulls
> out
> the ones that i do have a match . Is there another function that I
> could
> use that would only pull out the ones that there is not a match?
>
> =IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),"",A1)
> Thanks