Can I list the results of a range of cells in one cell? SOLV

[nancyo]

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

 

[ylijohe]

Jess!

http://www.geocities.com/ylijohe/excelsolutions.html

click PASSFAIL

 

[rikrak]

On 2002-09-13 13:02, ylijohe wrote:
Jess!

http://www.geocities.com/ylijohe/excelsolutions.html

click PASSFAIL

Very nice!
Are you sponsored by MrExcel?

 

[ryancarver]

I would number cells to the left then use an if statement to display a desired response if the cells in question meet a criteria ex. if(a2=5,a1,""); if(a2<>5,a1,""). Use the concatenate function at the bottom to put them all together into one cell and set the cell to wrap to adjust the height of the cell to include everything.

 

[nancyo]

Well, this appears to be exactly what i want!!!!! i will try to figure it all out over the weekend and monday.

Thanks!!

I'll post back if i have any questions.

 

[nancyo]

OK - All set. Following the PASSFAIL in the website hyperlink worked. I was able to actually evaluate multivariables in two columns!!!

Thanks for all the help!!!