budfox
New member
Hi all, and please forgive me for joining just to post a single question. I've been working on something very high-end, as you can tell from the thread title. I've made my little spreadsheet do almost everything I need, but I'm stuck on this:
I want a cell to include all of the names from a column A who have chosen a certain selection from columns B, C and D.
This table should explain it:
So my first row in the 'order' sheet will read "Cheese on Brown with Butter" in the first column, and the second column will read "John, Ringo"
Obviously I'd then go on to make a row for every sandwich option, with the second column returning the names of those who have made that choice.
I hope that's explained well enough, and I really would appreciate a pointer as to the formula I'm trying to write. Until this point I've worked things out, and I can display nice list of orders, but the final "who ordered what" step has got me stumped hwell:
Many thanks for any help.
Steve
I want a cell to include all of the names from a column A who have chosen a certain selection from columns B, C and D.
This table should explain it:
Name | Filling | Bread | Butter |
John | Cheese | Brown | Yes |
Paul | Ham | White | Yes |
George | Chicken | White | No |
Ringo | Cheese | Brown | Yes |
Dave | Cheese | White | No |
Martin | Egg | White | No |
Pete | Bacon | Brown | No |
So my first row in the 'order' sheet will read "Cheese on Brown with Butter" in the first column, and the second column will read "John, Ringo"
Obviously I'd then go on to make a row for every sandwich option, with the second column returning the names of those who have made that choice.
I hope that's explained well enough, and I really would appreciate a pointer as to the formula I'm trying to write. Until this point I've worked things out, and I can display nice list of orders, but the final "who ordered what" step has got me stumped hwell:
Many thanks for any help.
Steve