andersen_yunan
New Member
- Joined
- Feb 7, 2018
- Messages
- 36
Hi, so I got this raw data
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
and I want to make drop down list with multiple condition (in this case, class and hobbies will be the dropdown) that will result in specific name, like this
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
Is there any excel formula that I could use to get this result?
Any help would be appreciated. Thanks in advance!
Name | Class | Hobbies |
Andrew | Apple | Swimming |
Ricky | Apple | Reading |
Edwin | Orange | Tennis |
James | Pear | Reading |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
and I want to make drop down list with multiple condition (in this case, class and hobbies will be the dropdown) that will result in specific name, like this
Class | Apple |
Hobbies | Reading |
Name | |
Ricky | |
- | |
- | |
- |
<colgroup><col width="64" style="width:48pt" span="2"> </colgroup><tbody>
</tbody>
Is there any excel formula that I could use to get this result?
Any help would be appreciated. Thanks in advance!