Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I find data excluded from a list in excel?
HI,
Let say I have the following list in cells B2 to B10: "B2, B3, B4, B5, B6, B7, B8, B9, B10". After some manipulations, I have selected the following from the list:"B2, B3, B4, B8, B9, B10" in cells C2 to C7. I then would like to display in cells C8 to 11 the data that have not been selected in cells C2 to C7. How do I go about setting this up without using multiple nested if statements? Or a simplified version of the above: Let say I have the letters "A" in cell B2, "B" in cell B3, and "C" in cell B4. In cell C2 and C3 I enter two of the letters. (For example, I enter in cell C2 the letter "A" and in cell C3 I enter "C"). In cell C4 I want to display the letter that has not been selected (which should be "B"). How do I go about setting this up without using multiple nested if statements? Thanks, |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2002: How to find only the required data in a list ? | Excel Discussion (Misc queries) | |||
HOW DO I TOTAL A FILTERED LIST TO EXCLUDE THOSE EXCLUDED BY FILTE. | Excel Worksheet Functions | |||
Is there a function that allows me to list the names of excluded d | Excel Worksheet Functions | |||
HOW DO I EXCLUDED A FIGURE FROM A CONDITIONAL FORMAT???? | Excel Worksheet Functions | |||
How do I find data from a list (or table) and insert it in a row? | Excel Discussion (Misc queries) |