djgenesis13
New Member
- Joined
- Apr 24, 2014
- Messages
- 22
I want to search (with a formula) for a value and get the header of the column it exists (preferably without a "helper" column)
<colgroup><col span="9"></colgroup><tbody>
</tbody>
Could anyone help?
I have this table... | ||||||||
A | B | C | D | E | F | G | H | I |
1 | January | February | March | April | May | June | July | |
2 | 1 | X | X | X | X | A | X | X |
3 | 2 | X | X | B | X | X | X | X |
4 | 3 | X | X | X | X | X | X | X |
5 | 4 | X | X | X | X | X | X | C |
6 | 5 | X | X | X | X | X | X | X |
7 | 6 | X | X | X | D | X | X | X |
8 | 7 | X | X | X | X | X | E | X |
I want to get these results | ||||||||
10 | A | May | ||||||
11 | B | March | ||||||
12 | C | July | ||||||
13 | D | April | ||||||
14 | E | June |
<colgroup><col span="9"></colgroup><tbody>
</tbody>
Could anyone help?