andersen_yunan
New Member
- Joined
- Feb 7, 2018
- Messages
- 36
Hi, so I got this raw data
<colgroup><col width="64" style="width:48pt" span="6"> </colgroup><tbody>
</tbody>
and I want to make it like this (the name will have drop down list which would automatically change the result if I choose different name of people)
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Is there any excel formula that I could use to meet the results? I'm thinking of using index, match and transpose but couldn't find better way to solve this
Thanks in advance!
Name | Count | Score | |||
Andrew | 5 | 98 | 99 | 76 | 82 |
Christine | 2 | 56 | 88 | ||
Randall | 5 | 82 | 88 | 82 | 76 |
Kylie | 5 | 54 | 66 | 63 | 77 |
<colgroup><col width="64" style="width:48pt" span="6"> </colgroup><tbody>
</tbody>
and I want to make it like this (the name will have drop down list which would automatically change the result if I choose different name of people)
Andrew |
98 |
99 |
76 |
82 |
<colgroup><col width="64" style="width:48pt"> </colgroup><tbody>
</tbody>
Is there any excel formula that I could use to meet the results? I'm thinking of using index, match and transpose but couldn't find better way to solve this
Thanks in advance!