Hi,
I have a table which looks like this:
What I want is a macro or formulas in which i can chosse or write a name in a cell and it will bring me the HEADINGS AND RESULTS for the values that are not 0 that correspond to that name. Like this:
Basically this is so i can extract the information cleanly from very large table and crete a graph.
Thanks for Any Help!!
I have a table which looks like this:
Libro2 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
B | C | D | E | F | G | H | I | J | K | L | |||
2 | Test | Test1 | Test2 | Test3 | Test4 | Test5 | Test6 | Test7 | Test8 | Test9 | Test10 | ||
3 | Juan | 10% | 0% | 10% | 0% | 0% | 0% | 0% | 0% | 0% | 0% | ||
4 | Antonio | 0% | 10% | 0% | 10% | 0% | 10% | 0% | 10% | 0% | 0% | ||
5 | Fernando | 0% | 0% | 10% | 0% | 10% | 0% | 10% | 10% | 0% | 0% | ||
6 | Andres | 0% | 0% | 0% | 0% | 0% | 10% | 0% | 0% | 0% | 0% | ||
7 | Felipe | 10% | 0% | 10% | 10% | 10% | 0% | 0% | 0% | 0% | 0% | ||
Hoja1 |
What I want is a macro or formulas in which i can chosse or write a name in a cell and it will bring me the HEADINGS AND RESULTS for the values that are not 0 that correspond to that name. Like this:
Libro2 | |||||||
---|---|---|---|---|---|---|---|
B | C | D | E | F | |||
11 | Test3 | Test5 | Test7 | Test8 | |||
12 | Fernando | 10% | 10% | 10% | 10% | ||
Hoja1 |
Basically this is so i can extract the information cleanly from very large table and crete a graph.
Thanks for Any Help!!