I have a participation in the record of sheets every month by members with several accounts, initially I used the main account to track the main winner, but after adding a tab to consolidate the accounts per member, I am struggling to create a function to return the highest general income every month. .
Link to GSheet: https://docs.google.com/spreadsheets/d/1lHn2Um92-YIMUsXp8JJbf4IMwj6uAJ8esjdBHW-SSc0/edit?usp=sharing
Example: In the & # 39; November & # 39; tab, Gambit 306 is the account with the most PaP, which is in the & # 39; Summary & # 39; tab.
However, Ekiesta has most of all accounts associated with that member as shown in the & # 39; Char / Alt & # 39; tab.
Total loss of how to start replacing the call in the cells of the & # 39; Main Winner & # 39; from the Summary tab to return the main account with the highest Paps in the & # 39; Char / Alt & # 39; tab.