| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
displaying missing data with a formula
I have three cols
red green missing blue yellow missing green brown missing white yellow brown How do I compare the second col with the first col to display the missing data in the 3rd col which should read red, blue, white. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
displaying missing data with a formula
Shu,
Array enter (enter using Ctrl-Shift-Enter) this formula in C1: =INDEX($A$1:$A$6,LARGE(ISERROR(MATCH($A$1:$A$6,$B$ 1:$B$3,FALSE))*ROW($A$1:$A$6),ROW(A1))) and copy down to C2:C3. HTH, Bernie MS Excel MVP "Shu of AZ" wrote in message ... I have three cols red green missing blue yellow missing green brown missing white yellow brown How do I compare the second col with the first col to display the missing data in the 3rd col which should read red, blue, white. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| displaying missing data by comparing two sets | Excel Discussion (Misc queries) | |||
| Excel formula not displaying target data | Excel Programming | |||
| Displaying missing values | Excel Discussion (Misc queries) | |||
| eliminating types of missing data from final formula | Excel Discussion (Misc queries) | |||
| linked cell is displaying formula instead of the data | Excel Worksheet Functions | |||
Linear Mode
