I run a daily golf league where the number of players is not consistent.  The data is removed after every use.  I use multiple tables that randomly creates teams using RAND function.  It also sorts and rank player performance and sum winnings from 3 tables (team performance, individual performance and skins).  Every time I use the workbook, I need to manually adjust the table sizes in multiple pages since any #N/A or #VALUE! in a table will interfere with sum, match, vlookup, sorting and rank functions.  Is there a way to automatically adjust the number of rows in all of the tables based on the the number of players (PLAYER COUNT)?

​I run a daily golf league where the number of players is not consistent.  The data is removed after every use.  I use multiple tables that randomly creates teams using RAND function.  It also sorts and rank player performance and sum winnings from 3 tables (team performance, individual performance and skins).  Every time I use the workbook, I need to manually adjust the table sizes in multiple pages since any #N/A or #VALUE! in a table will interfere with sum, match, vlookup, sorting and rank functions.  Is there a way to automatically adjust the number of rows in all of the tables based on the the number of players (PLAYER COUNT)?  Read More

​