Hello,
I am looking for some help with a formula. In one column, I have a set of data that could be as long as 200 rows. In the next column, a user will key in an "X" in the corresponding cells for those items they wish to select. Most of the time, the users will be selecting less than 10 items but it could be as many as 25. I need a cell with an output of those selections sorted numerically first and then alphanumerically at the end. The data options will not be sorted in any particular way so the sort needs to happen within the formula. (It isn't feasible to sort the data list by the way.)
I think the SMALL formula could be used for the numeric values but I am not certain how to get the text entries added into the list at the end.
Although my project is more complex, here is a small example to illustrate what I am looking for. By the way, I prefer to do this without using an array formula or VBA if possible.
Can this be done? I would appreciate any help you can provide. (By the way, I am using Excel 2000)
Thank you.
I am looking for some help with a formula. In one column, I have a set of data that could be as long as 200 rows. In the next column, a user will key in an "X" in the corresponding cells for those items they wish to select. Most of the time, the users will be selecting less than 10 items but it could be as many as 25. I need a cell with an output of those selections sorted numerically first and then alphanumerically at the end. The data options will not be sorted in any particular way so the sort needs to happen within the formula. (It isn't feasible to sort the data list by the way.)
I think the SMALL formula could be used for the numeric values but I am not certain how to get the text entries added into the list at the end.
Although my project is more complex, here is a small example to illustrate what I am looking for. By the way, I prefer to do this without using an array formula or VBA if possible.
Can this be done? I would appreciate any help you can provide. (By the way, I am using Excel 2000)
Thank you.
| Book1 | |||||||
|---|---|---|---|---|---|---|---|
| A | B | C | D | E | |||
| 1 | Option | Select? | Output: | 1,4,6,8,10,CAT,DOG | |||
| 2 | 1 | X | |||||
| 3 | 2 | ||||||
| 4 | 3 | ||||||
| 5 | 5 | ||||||
| 6 | 6 | X | |||||
| 7 | 4 | X | |||||
| 8 | 7 | ||||||
| 9 | DOG | X | |||||
| 10 | 8 | X | |||||
| 11 | CAT | X | |||||
| 12 | 9 | ||||||
| 13 | 10 | X | |||||
| 14 | MOUSE | ||||||
| 15 | 11 | ||||||
Sheet1 | |||||||
