Forum Discussion
Formula assistance please
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?
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.
