Help with Sorting/Max/Large Functions
I have a that I use to track Board games played. I have all games organized in a table with name of Board Games (A), Times played (B), Last Date Played (C), Time to Play (D), Times played in 2025 (E) and times played in 2026 (F). I have the sheet set up where I can log the game and it automatically updates. There are other nice functions like tracking how often someone plays a game, what place people get when playing etc. Right now I have a table that shows the top games played for the year and the top games overall.
What I need help with is: creating a table that shows the top "long games" played. This would be any game with a Time to Play Value greater than 60 minutes. So how would I find the first, second and third most played long games with an automatic function?
=MAXIFS(B:B,D:D,">60") shows the correct number of times played and
=INDEX(A:A, MATCH(MAXIFS(B:B,D:D,">80"),B:B, 0)) shows the correct board game name associated with that Times played value.
I've tried =LARGE(IF(D2:D,B2:B,">60"), 2) to find the second largest value but it keeps turning up the wrong number.
And before you judge me, my children love Candyland. Probably because we put smarties out and claim them when you land on the space.
Please let me know if you need a link with a copy of the spreadsheet to help solve my issue