scoobysteph
New Member
- Joined
- Apr 12, 2018
- Messages
- 1
Hello everyone,
I'm trying to create ranked subset lists from a 'master' ranked list and have subset lists update dynamically as changes are made to the master list. Boiling it down to a very simple example below:
What I have (sample master list) of overall rankings:
<tbody>
</tbody>
What I want is to have separate rankings by subset that is updated as changes are made to the master ranking list:
<tbody>
</tbody>
Hopefully there's a way to do this with formulas. I'm getting confused as to where to start because most of it is based on text inputs. I'm not familiar with VBA so I hope there's a way to use count/match/index for this....
THANK YOU!
I'm trying to create ranked subset lists from a 'master' ranked list and have subset lists update dynamically as changes are made to the master list. Boiling it down to a very simple example below:
What I have (sample master list) of overall rankings:
| 1 | Vegetable | Carrot |
| 2 | Vegetable | Onion |
| 3 | Fruit | Apple |
| 4 | Junk Food | Chips |
| 5 | Junk Food | Popcorn |
| 6 | Fruit | Lemon |
| 7 | Fruit | Lime |
| 8 | Vegetable | Potato |
<tbody>
</tbody>
What I want is to have separate rankings by subset that is updated as changes are made to the master ranking list:
| Vegetable | Fruit | Junk Food | |||||
| 1 | Carrot | 1 | Apple | 1 | Chips | ||
| 2 | Onion | 2 | Lemon | 2 | Popcorn | ||
| 3 | Potato | 3 | Lime | ||||
<tbody>
</tbody>
Hopefully there's a way to do this with formulas. I'm getting confused as to where to start because most of it is based on text inputs. I'm not familiar with VBA so I hope there's a way to use count/match/index for this....
THANK YOU!
