Forum Discussion
HOW TO MAKE 3 TABLES RANGE DYNAMIC WITHOUT CONVERTING IT WITH TABLE
HI ALL, AS I HAVE 3 TABLES IN FINAL DATA SHEET. 1ST IS DEAL SUMMARY TABLE WHICH IS EXIST IN DEAL SUMMRAY SHEET 2ND IS CONTACT LIST TABLE WHICH IS EXIST IN CONTACT LIST SHEET 3RD IS REFERENCE COMP...
If a given table is simply pulling from another sheet, you might try this:
'Feed' is where the data is coming from. In this sample I set it to 50 rows (Can be increased as needed). The formula determines how many blanks are in the range and drops them from the pull.
=LET(data,Feed!A1:K50,blanks,COUNTBLANK(TAKE(data,,1)),DROP(data,-blanks))
- let function is from excel 365 i can't use it ... i can use only upto excel 2016