My Data Range is B2:G9 (which contains values) with ‘HEADER’ in B1:G1 (Non -numeric)
‘switches’ are in B12:G12 which are EITHER 0 OR 1; AND at a time ONLY 1 ‘SWITCH‘ FOR A 'UNIQUE’ HEADER WILL HAVE 0 OR 1
UNIQUE’ HEADERS are in I1:J1
Output is required in I2:J9 as:
Match UNIQUE’ HEADERS with switch value equal to 1 and grab the corresponding value from B2:G9
How to accomplish?
Thanks in advance.
I am using Excel 2007.