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 group. I will already have the drivers names and starting position for their heat race on one tab and wanting to come up with a formula that once I put in their finish from the heat that it automatically calculate their points looking at the passing points tab (2nd tab) from where they stated and finished and pull their points. Any suggestions? Thanks for your assistance.
19 Replies
This can be done with an INDEX-MATCH (I've created some named items to make the formula more readable.
=IFNA(INDEX(points,MATCH(E4,Finish,0),MATCH(D4,StartingPosition,0)),"")You'll have to fill me in on Pill# and if that needs to be addressed for ties.
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?
Hi Race_Mom
could you please upload your example file with some descriptions in it, so we could better understand what it looks like and provide maybe a solution.
And also please let us know which version of Excel you are use, because in some cases this might be affect a proposed solution.
Martin_Weiss I am using 2016. Having issues with how to upload. suggestions?
Hi Race_Mom
under each reply, there is a little hyperlink where you can open the full text editor:
In that editor, there is some space at the bottom where you can upload your files:
- It sounds do-able. Do you happen to have a sample workbook you can share?
Patrick2788 Wonderful! I figured if I can think it Excel could do it. I am using Microsoft Office Professional 2016. I am having issues on how to attach my workbook. suggestions?
