# Need Help With Formula

#### hitoshiluvsmilk

##### New Member
I've been messing with this all day, but can't seem to get it to come out right. I'm in a 12-team Head-2-Head fantasy basketball league and I'm trying to set up a scoring system for my own use. Here's what I'm looking to do:

Create a formula for each stat category that determines who is first, second, third, etc. in that category. For example, take the category 'points'. I need a formula that will look at a set of values, and whoever has the most points, I want to return a value of '1', return a '2' value for the second most points, and all the way down to the person with the least points, giving them a '12'. Can anybody help me with this? The IF function only supports 7 nested sets, so I didn't think that would work since there are 12 teams. I'm not even sure which function to use at this point.

Thanks,

Hitoshi

### Excel Facts

Which came first: VisiCalc or Lotus 1-2-3?
Dan Bricklin and Bob Frankston debuted VisiCalc in 1979 as a Visible Calculator. Lotus 1-2-3 debuted in the early 1980's, from Mitch Kapor.
hi - welcome to the board!

review the excel help file for 'rank' and search the board for 'unique rank' if you don't want ties.

Replies
6
Views
180
Replies
9
Views
166
Replies
5
Views
267
Replies
6
Views
268
Replies
6
Views
251

1,207,402
Messages
6,078,268
Members
446,324
Latest member
JKamlet

### 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