I want to automatically update the top 3 leaderboard for my powerlifting team based on results entered in another tab.
Hello! I have been trying to figure out a way to automatically update my top 3 leaderboard for my powerlifting team's records based on the meet results. If you look on the "Girls Leaderboard" tab, I have a section for each weight class and then 3 rows for the top 3, and then a column for squat, bench, deadlift, and total for the weight classes. I would like to pull it from the All Lifters Meets tab as that is where my data entry goes. This tab specifically is only for the girls. I have a separate one for the boys that will also need a formula but I assume the only thing that will change is the part where it checks the Sex column. I want the top 3 lifters and the weight lifted for each of those 4 columns, for each weight class. I haven't really gotten the hang of lambda or any of the other complex versions of a formula that would accomplish this so anything would help. [Here is the spreadsheet!](https://docs.google.com/spreadsheets/d/1Z7O4JExTGS0V8AhKH1NzPJfU9g4Ne9XqyLGcqeUF4ZM/edit?usp=sharing)