This is my sample datasheet.......
What I need is a formula to extract the "Yes" answers into a comma separated string as per column G; so where answer is "yes" in line 2, (or whichever line the answer is on) bring back the code in line 1 for each column A to F. I have tried a number of nested IF statements but cant seem to get it right - any help will be greatly appreciated
Thanks
Simon
A | B | C | D | E | F | G | |
1 | 100 | 200 | 300 | 400 | 500 | Result | |
2 | Customer A | Yes | Yes | No | Yes | No | 100,200,400 |
3 | Customer B | Yes | Yes | No | Yes | Yes | 100,200,400,500 |
4 | Customer C | No | Yes | Yes | No | No | 200,300 |
What I need is a formula to extract the "Yes" answers into a comma separated string as per column G; so where answer is "yes" in line 2, (or whichever line the answer is on) bring back the code in line 1 for each column A to F. I have tried a number of nested IF statements but cant seem to get it right - any help will be greatly appreciated
Thanks
Simon