Forum Discussion
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...
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?
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
Patrick2788 I love how that formula came out. I really owe you one. Any suggestions on how to get the line of for the feature to fill in automatically from the points that got figured from the heat race? I really need to send you a gift card or something for all your help. Thanks