JackDanIce
Well-known Member
- Joined
- Feb 3, 2010
- Messages
- 9,922
- Office Version
- 365
- Platform
- Windows
Hi,
I have a cross-tab reference table sheet Data with projects listed vertically, job titles horizontally and matrix for yes and no (1 and 0)
In sheet Output, I have the same projects listed horizontally and underneath each project, I need to list the job titles based on the reference table.
What formula could I use to return this output?
TIA,
Jack
Workfile KS v5.9.xlsb | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | |||
2 | Ref Table | Output | ||||||||||
3 | ||||||||||||
4 | CEO | IT Director | Sales | Intern | A | B | C | D | ||||
5 | A | 1 | 1 | 1 | 0 | CEO, IT Director, Sales | CEO | CEO, IT Director | CEO, IT Director, Sales, Intern | |||
6 | B | 1 | 0 | 0 | 0 | |||||||
7 | C | 1 | 1 | 0 | 0 | |||||||
8 | D | 1 | 1 | 1 | 1 | |||||||
Sheet1 |
I have a cross-tab reference table sheet Data with projects listed vertically, job titles horizontally and matrix for yes and no (1 and 0)
In sheet Output, I have the same projects listed horizontally and underneath each project, I need to list the job titles based on the reference table.
What formula could I use to return this output?
TIA,
Jack