Forum Discussion
Race_Mom
Jan 29, 2023Copper Contributor
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...
Race_Mom
Feb 10, 2023Copper Contributor
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.
Patrick2788
Feb 11, 2023Silver Contributor
The 'newest' function used in that formula above is IFNA (It came out with Excel 2013). Which version of Excel do you have?
- Race_MomFeb 11, 2023Copper ContributorIt works awesome now. I think I put in the draft formula as the one I see now has more items
- Race_MomFeb 14, 2023Copper Contributor
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
- Patrick2788Feb 15, 2023Silver ContributorCan the feature line up come from any of the 3 heats listed above?