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?

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?