Forum Discussion
Formula assistance please
Patrick2788 thank you so much for getting me going in the right direction. The pill # is a number the racer pulls for their starting position for the heat race. Therefore if a driver ends up with the same number of passing points then whoever has the smaller pill number will get placed before the other.
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?
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.
- Patrick2788 sorry for the late response. It has been a crazy week at work. There will not be any additional points awarded to break the tie. I just need to put them in order accordingly. I input your earlier formula but I received an error saying #Name.
- The 'newest' function used in that formula above is IFNA (It came out with Excel 2013). Which version of Excel do you have?
- It works awesome now. I think I put in the draft formula as the one I see now has more items