HeyItsDizzy
New Member
- Joined
- Apr 11, 2018
- Messages
- 20
Hi Guys. I am new to this forum, and not sure how to place my actual excel cells in here...
Ok. So I will explain as best I can, I am after a formula (not a macro) to Take player preference and auto-generate a list; in this example, there are only 2 rewards and only 5 rewards available each.
so the players with the highest score will get to pick their preferred prize first.
However as you can see (in column B) 7 players want the Puppy, And only 3 want the Dinosaur
if each person took their prize one by one in order of their high scores the player reward handouts would like they do in columns E and F
I have assigned a Value number to the type of prize for use with a Vlookup function, or any other formula that will read those numbers as a value/code type thing, (I also know that Vlookup only work from left to right and will not go backwards, therefore I am happy to duplicate the name columns, and reward type columns etc if need be so that a formula such as that will work
I don't mind how many separate calculations/columns and/or rows need to be placed (i can make another cell array if that is also required)
I would just like to know the best way to get my 'A2:C11' range looking like my 'E:F' column range based on the placement results
<tbody>
</tbody>
Ok. So I will explain as best I can, I am after a formula (not a macro) to Take player preference and auto-generate a list; in this example, there are only 2 rewards and only 5 rewards available each.
so the players with the highest score will get to pick their preferred prize first.
However as you can see (in column B) 7 players want the Puppy, And only 3 want the Dinosaur
if each person took their prize one by one in order of their high scores the player reward handouts would like they do in columns E and F
I have assigned a Value number to the type of prize for use with a Vlookup function, or any other formula that will read those numbers as a value/code type thing, (I also know that Vlookup only work from left to right and will not go backwards, therefore I am happy to duplicate the name columns, and reward type columns etc if need be so that a formula such as that will work
I don't mind how many separate calculations/columns and/or rows need to be placed (i can make another cell array if that is also required)
I would just like to know the best way to get my 'A2:C11' range looking like my 'E:F' column range based on the placement results
A | B | C | D | E | F | |
1 | Name | Pref type | Pref Value | Puppy | Dinosaur | |
2 | Dizzy | Puppy | 1 | Dizzy | Arvo | |
3 | Zenaku | Puppy | 1 | Zenaku | BeginJehan | |
4 | Arvo | Dinosaur | 2 | BennyBoo | BetterQuad | |
5 | BeginJehan | Dinosaur | 2 | BennyBwoy | Cubosh | |
6 | Bennyboo | Puppy | 1 | Corzza | HadLowJ | |
7 | BennyBwoy | Puppy | 1 | |||
8 | BetterQuad | Dinosaur | 2 | |||
9 | Corzza | Puppy | 1 | |||
10 | Cubosh | Puppy | 1 | |||
11 | HadLowJ | Puppy | 1 |
<tbody>
</tbody>