| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
MATCH() and ISERROR() to extract set differences
If A and B are columnar arrays, and you want to subtract set B from set A, try this:
C1 =MATCH(A1,$B$1:$B$n,0) This returns an error if the value of A1 does not appear anywhere in the range B1:Bn. Then D1 =IF(ISERROR(C1),A1,"") Column D now contains only the values of A which are not found in B. EggHeadCafe - .NET Developer Portal of Choice http://www.eggheadcafe.com/default.aspx?ref=ng |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF ISERROR INDIRECT MATCH Formula Question??? | Excel Worksheet Functions | |||
| IF ISERROR with index match | Excel Programming | |||
| Condense ISERROR(VLOOKUP(MATCH())) to VBA function. | Excel Programming | |||
| IsError and Match function | Excel Programming | |||
| IF(ISERROR(MATCH - need value where match was found | Excel Programming | |||
Threaded Mode
