In this video, I demonstrate a formula solution to ExcelBI's challenge where we are required to pick out the Top N from a list of players and their active years playing with the Indian cricket team
Link to workbook:
https://docs.google.com/spreadsheets/...