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

#### nancyo

##### Active Member
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

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.
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.

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.

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!!!

Replies
10
Views
290
Replies
1
Views
239
Replies
10
Views
268
Replies
2
Views
243
Replies
1
Views
637

1,218,575
Messages
6,143,313
Members
450,477
Latest member
teresab543

### 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.

### Which adblocker are you using?

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

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