Hi,
my sports club is organising an auction for charity.
people can do a bid for playing against the world champion biliards.
We are selling 4 matches so the people can also tell which rounds they can/will play.
After making a list with all the bids and some sorting, i end up with something like this:
name - bid - date - time - round1 - round2 - round3 - round4
John - 100 - 24/9 - 17:30 - 0 - 2 - 3 - 4
William - 75 - 24/9 - 15:00 - 1 - 2 - 3 - 4
Eva - 50 - 23/9 - 19:00 - 1 - 2 - 3 - 4
George - 50 - 24/9 - 15:00 - 1 - 2 - 3 - 4
The highest bid may play first then the second highest etc.
With exeption for the bids wich are not for every round.
So i want to translate this to a final table like:
round1 - round2 - round3 - round4
William - John - Eva - George
75 - 100 - 50 - 50
There is only a problem: i don't know how.
Can somebody please help me?
my sports club is organising an auction for charity.
people can do a bid for playing against the world champion biliards.
We are selling 4 matches so the people can also tell which rounds they can/will play.
After making a list with all the bids and some sorting, i end up with something like this:
name - bid - date - time - round1 - round2 - round3 - round4
John - 100 - 24/9 - 17:30 - 0 - 2 - 3 - 4
William - 75 - 24/9 - 15:00 - 1 - 2 - 3 - 4
Eva - 50 - 23/9 - 19:00 - 1 - 2 - 3 - 4
George - 50 - 24/9 - 15:00 - 1 - 2 - 3 - 4
The highest bid may play first then the second highest etc.
With exeption for the bids wich are not for every round.
So i want to translate this to a final table like:
round1 - round2 - round3 - round4
William - John - Eva - George
75 - 100 - 50 - 50
There is only a problem: i don't know how.
Can somebody please help me?
