I need help with grouping together responses in a workbook. I am using Excel 2010 and I have columnA with Categories 1,2,3,4,5 and 6. ColumnB has the responses A,B,C, and D from a pull-down list (A,B,C, and D are all defined in cells elsewhere in the spreadsheet and then referenced for the data validation drop-down list). Lets say the responses are 1-A,2-A,3-B,4-D,5-A,6-B. I want a formula in a different cell that will give me "1,2 and 5 are A; 3 and 6 are B; 4 is D" maybe not that cleanly but as close as possible to that. I do NOT want answers that use VBA or macros, even if it is not possible without them. I would just like to know if there is any way at all this could be done using any combination of formulas.
I have provided a sample with the necessary information towards the bottom using sample info such as school supplies and their availability (all the cell references will be easily transferable to my actual workbook due to the placement here). The dropdown list choices are defined starting in B294:B299, in case that is important (again, this is just to mirror the way it is setup in my actual file).
Here is the link to the sample. https://drive.google.com/file/d/0B5qnLtwIDvK7TjV0TTJOSnNNRU0/view?usp=sharing Please let me know what you can come up with! Thanks!
I have provided a sample with the necessary information towards the bottom using sample info such as school supplies and their availability (all the cell references will be easily transferable to my actual workbook due to the placement here). The dropdown list choices are defined starting in B294:B299, in case that is important (again, this is just to mirror the way it is setup in my actual file).
Here is the link to the sample. https://drive.google.com/file/d/0B5qnLtwIDvK7TjV0TTJOSnNNRU0/view?usp=sharing Please let me know what you can come up with! Thanks!