|
| 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
March 7th, 2010, 02:17 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Matching function or no match
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 
|
|
#2
March 7th, 2010, 03:32 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching function or no match
Uh
=IF(ISERROR(MATCH(A1,$C$1:$C$5,0)),A1,"") -- HTH Bob "Donna" wrote in message ... 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
|
|
#3
March 7th, 2010, 03:44 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching function or no match
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
|
|
#4
March 7th, 2010, 06:14 PM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Matching function or no match
Another one...
=IF(COUNTIF(C$1:C$5,A1),"",A1) -- Biff Microsoft Excel MVP "Donna" wrote in message ... 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
