I would like a formula that returns the column and row name, based on "Yes"/"No" response in a table array. Please see below. Basically, I would like a formula that automatically returns the values in the last row below (excel attached):
SCENARIO A B C D E 1 Yes No No No No 2 No No No Yes No 3 No Yes Yes No No 4 No No No No Yes 5 No No No No No Return the following scenarios, based on above "Yes" response Scenarios 1A 2D 3B 3C 4E