# prize

1. ### Excel - non vba code - Calculate Prize Money by Place

Prizes are award to individual players by Flight; 5 places are paid, in the event of a tie, the prize money is distributed between the players and rounded to the nearest whole dollar amount; i.e., Player 3, 4 and 5 are tied for 2nd place – the prize award for 2nd place is \$6, 3rd place is \$5 and...
2. ### Help: Raffle Name Picker 250 Prizes, 0 Duplicates with Multiple Entries per Person

So I am looking to pick 250 unique winners for a contest. The contest will have 10k-20k unique users. Each user is able to enter multiple times. How do i Pick 10 unique users for 1 prize How do i Pick 240 unqiue users for 2nd prize If your name was picked for any of these prizes it needs to...
3. ### Random name picker

Hello I hope someone can help me quickly :eeek: I am looking to create a spreadsheet to be used once a month for a prize draw we do for 3 random names. I get sent a list of around 100 people and each month I need to randomly pick 3 names from that list (1st prize, 2nd prize and 3rd prize)...
4. ### Help needed - count number of cells based on multiple criteria

Hi guys, Can anybody help me with a formula <tbody> A B C D E F G H I J K Buy-In Players Places Paid 1st(1) 1st(2) 1st(3) 2nd 3rd Pos Prize Profit /Loss 30 5 2 150 50 50 30 0 5 0 -30 15 4 1 125 20 20 0 0 1 20 5 15 8 2 90 40 20 25 0 4 0 -15 15 6 2 55 35 30 20 0 1 30 15 15 6 2 145 35...
5. ### Split the prize amounts for ties?

How do I create a formula to split the prize amounts for ties? (It's for a golf league) Player Score Rank Prize Rank Prize In this example the prize payout should be… A 70 1 ? 1 100...
6. ### Lookup cell and n cells below - return the average

Hi I am looking for a way to return the average of multiple cells using a vlookup. This is in respect of sporting prize money. Where a competitor finishes 1st, they get a set prize in \$ and I have set the Vlookup to return this figure where I input 1st as their position. It gets complicated...
7. ### How to calculate prize money when there are ties?

I am making a golf tournament pool and I am using the prize money for our points. I have listed the prize money for each position but there are always ties. there are 53 golfers from row 2 to 54. i have the positions (1 to 53) listed in column K (K2:K54) Position amounts (1st to 53rd) listed in...

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back