"fetzer" wrote
To Max,

All I can say is WOW! Your sample setup-file was great and I can't
thank you enough!

One question I have if you don't mind. At the end of the 26th race,
the top 10 drivers are reassigned, with the driver in the first
position receiving 5050 points, 2nd postion receives 5045, etc. Let's
say at the end of the 26th race, the driver in 1st has 3425 total
points. That driver then needs an additional 1625 points added to his
existing total to make it to 5050 points. Can I manually add those
additional points (1625) to column AC or AD or would an additional
column (AH) be better to add those points?

Thanks again for your help. You have some fantastic ideas.

Doug (fetzer)

You're welcome, Doug !

Some thoughts to extend the earlier set-up ..

See sheet: Y in the revised sample at:
http://www.savefile.com/files/9470681
Nascar Racing ranking set up_v2.xls

Assume the Top 10 "Final" Pts (fixed pot) is listed in AH3:AH12,
eg: 5050, 5045, 5040, ... 5005

Put
In AI3: =SUMIF(AE:AE,AE3,AH:AH)/COUNTIF(AE:AE,AE3)
In AJ3: =AI3-AG3
Select AI3:AJ3, copy down to AJ12

Col AI adjusts the fixed pot points in col AH for ties, if any, within the
top 10
Col AJ simply computes the points difference top-ups made to the totals in
col AG

--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---