Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions,microsoft.public.excel.programming
|
|||
|
|||
![]()
Not sure if I'm wording that right, or even if it's proper... or for that
matter, if what I'm talking about would be an inverse factorial(if there is such a thing)... but... I asked this elsewhere but may have put a header that caused people to not even read, so here goes again. Basically what I'm trying to do is take a random number of places, and divide 100% over those places, in a descending amount from first to last, with first being the highest percentage. IOW, let's say there were 4 places, the division would be something like 1st - 50% 2nd-25% 3rd-15% 4th-10% I may have as few as say the 4 places above, or maybe as many as 100. I don't know what that number will be. I'm no mathematician(as you can see from my header*g*) but I'd think that there has to be a mathematical formula to do this. Thanks! Shawn -- It's not just based on number of championships won. Richard Petty won 200 races and 7 Daytona 500s in his 30+ year driving career. He also has the most top-5s (555), top-10s (712), poles (126), laps completed (307,836), laps led (52,194), races led (599) and consecutive races won (10 in 1967) of any driver in NASCAR history. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
is it posible to have a formula for factorial via vba code? | Excel Worksheet Functions | |||
Factorial question | Excel Worksheet Functions | |||
Factorial Listing | Excel Discussion (Misc queries) | |||
Factorial (like =FACT) function? | Excel Worksheet Functions | |||
Range of Factorial Function | Excel Discussion (Misc queries) |