JackoExcel
New Member
- Joined
- Feb 3, 2015
- Messages
- 1
For example, pls see the table at the bottom of this post.
I would like to be able to input the start country into cell A1 and have excel return all values in the column above 0% and the corresponding headers.
I've tried with index but can only get the percentages, and not the corresponding headers.. any help would be appreciated! VBA or Otherwise.
so If I input Netherland, I would see:
<tbody>
</tbody>
And If I input Egpyt I would see:
<tbody>
</tbody>
<tbody>
</tbody>
I would like to be able to input the start country into cell A1 and have excel return all values in the column above 0% and the corresponding headers.
I've tried with index but can only get the percentages, and not the corresponding headers.. any help would be appreciated! VBA or Otherwise.
so If I input Netherland, I would see:
| Start | Finish | Percent |
| Netherland | ALGERIA | 20.00% |
| ANGOLA | 20.00% | |
| BAHAMAS | 40.00% | |
| BRAZIL | 20.00% |
<tbody>
</tbody>
And If I input Egpyt I would see:
| Start | Finish | Percent |
| Egypt | Bahamas | 100.00% |
<tbody>
</tbody>
| Finish | |||||
| ALGERIA | ANGOLA | BAHAMAS | BRAZIL | ||
| Start | CHINA | 0.00% | 100.00% | 0.00% | 0.00% |
| EGYPT | 0.00% | 0.00% | 100.00% | 0.00% | |
| Greece | 0.00% | 0.00% | 51.00% | 49.00% | |
| INDIA | 0.00% | 50.00% | 0.00% | 50.00% | |
| Netherland | 20.00% | 20.00% | 40.00% | 20.00% |
<tbody>
</tbody>
