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...
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
Can the feature line up come from any of the 3 heats listed above?
- Now you have totally lost me
- I believe this is possible in Excel 2016 but it's going to involve a contorted formula because of the possibility of ties and the lack of 365 functions.
Patrick2788 Hi Patrick! The feature race will come from all 3 heats. Highest points start first etc to 22nd being the lowest after you remove the last 2. We will only race 22 cars max. As mentioned before if anyone has a tie in points then the driver with the lowest pill for heat lineup goes ahead of others tied with. Not sure how difficult this will be to accomplish but I have no problem sorting them as a last resort. Thanks again and good luck!