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

nancyo

Active Member
Joined
Mar 25, 2002
Messages
255
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
 

Excel Facts

Bring active cell back into view
Start at A1 and select to A9999 while writing a formula, you can't see A1 anymore. Press Ctrl+Backspace to bring active cell into view.

ryancarver

New Member
Joined
Sep 12, 2002
Messages
4
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

Active Member
Joined
Mar 25, 2002
Messages
255
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

Active Member
Joined
Mar 25, 2002
Messages
255
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!!!
 

Forum statistics

Threads
1,143,640
Messages
5,719,985
Members
422,256
Latest member
downeybm

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top