Hi, I'm managing a sports database and one thing I want to do is create a table based on the last four matches between two players. I've got a formula that generates the matchup number between the players, and I thought a helper column stating whether it should be included or not would be good, but I'm not sure how to make it so it only counts the four largest numbers for a particular pairing.
I've attached a sample worksheet that includes the formula mentioned, and what it should look like, like so:
Capture.JPG
Hope someone can help. Thanks for looking.
Bookmarks