I have a range of cells (say, A1:A24), and in each cell is a formula that returns a "Pass" or "Fail". The corresponding column has a number associated with each cell. So, in cell B1, there is the number one.
I would like to set up another cell (say, A26), which woulld LIST all the cells that said "Pass". By this, cell A26 would have something like:
1, 2, 5, 6, 8, 10
A second cell would list all those that "Fail".
I realize that the size of the cell would have to be large, which I can do by merging with other cells.
I have looked in the help/search, and I am finding many SUM formulas, but not a way to list results. This may not be possible...
This message was edited by nancyo on 2002-09-13 12:25
This message was edited by nancyo on 2002-09-16 13:52
I would like to set up another cell (say, A26), which woulld LIST all the cells that said "Pass". By this, cell A26 would have something like:
1, 2, 5, 6, 8, 10
A second cell would list all those that "Fail".
I realize that the size of the cell would have to be large, which I can do by merging with other cells.
I have looked in the help/search, and I am finding many SUM formulas, but not a way to list results. This may not be possible...
This message was edited by nancyo on 2002-09-13 12:25
This message was edited by nancyo on 2002-09-16 13:52