Forum Discussion

Race_Mom's avatar
Race_Mom
Copper Contributor
Jan 29, 2023

Formula assistance please

My son races a sprint car and this year our group will be using passing points from a heat race to come up with the feature race line up.  I will be responsible for posting this information for the g...
Formulas and Functions
Patrick2788's avatar
Patrick2788
Silver Contributor
Feb 07, 2023

Race_Mom 

Here's an example of a situation where the points is the same for finishers:

Driver 'h' has the lower pill# with 1, while 'a' has 3. Both have 83 points.  Would you like to assign 'h' more points to break the tie or change something else?

Race_Mom's avatar
Race_Mom
Copper Contributor
Feb 10, 2023

Patrick2788Just checked out the workbook you attached and it worked perfectly. This will really help me out when preparing the line ups for the feature. Now my next question is to come up with the easiest way to get my feature. My only thought was to copy the 3 heat finishes into a column with their points & pill # and do a sort and then just cut and paste into the feature line up section. I know you are probably shaking your head at me now. LOL.  Thanks so much for helping me.  Hoping you can come up with the next step, getting it automatically to the feature line up.