Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Is there a function that allows me to list the names of excluded d
For example, if I am using 0 or 1 for deselecting or selecting data, I would
like to have a cell that says: "Exlcuded from data: data point 1, data point 2, etc.." everytime I have a 0 next to the data point. Is there a command for this? |
#2
|
|||
|
|||
Hi
Do you want the actual data point (position) or the data from that point? For instance: A..........B Tom.....1 Joe.......1 Sue.......0 Eric.......1 Lee.......0 Tony.....1 Rich......0 Bob......0 John......1 Vicky....0 Do you want: 3 5 7 8 10 OR: Sue Lee Rich Bob Vicky If you want the data point positions which are relative to their position in an array and not the actual physical location. Assume the data is in the range A1:B10. Entered with the key combo of CTRL,SHIFT,ENTER. =IF(ISERROR(SMALL(IF(B$1:B$10=0,ROW($1:$10)),ROW(1 :1))),"",INDEX(ROW(A$1:A$10),SMALL(IF(B$1:B$10=0,R OW($1:$10)),ROW(1:1)))) Copy down until you get blanks. If you want the actual data from those points: Entered with the key combo of CTRL,SHIFT,ENTER. =IF(ISERROR(SMALL(IF(B$1:B$10=0,ROW($1:$10)),ROW(1 :1))),"",INDEX(A$1:A$10,SMALL(IF(B$1:B$10=0,ROW($1 :$10)),ROW(1:1)))) Biff "Flutie99" wrote in message ... For example, if I am using 0 or 1 for deselecting or selecting data, I would like to have a cell that says: "Exlcuded from data: data point 1, data point 2, etc.." everytime I have a 0 next to the data point. Is there a command for this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Creating Drop Down boxes with the List function... | Excel Discussion (Misc queries) | |||
How do I filter a list using a greater than todays date function? | Excel Worksheet Functions | |||
subtotaling and manipulating a list of data | Excel Worksheet Functions | |||
If function using a list of criteria | Excel Discussion (Misc queries) | |||
How do I find out what items are in one list but not in another l. | Excel Discussion (Misc queries) |