I have some formulas looking up specific row numbers in an Excel table. When the table refreshes if the number of rows in it adjusts then the formula returns an error.
Is there a way of fixing this? Basically I want to always look at only the first 500 records in the table post-refresh (Rows 9 to 508).
Any help much appreciated!
Baker
Is there a way of fixing this? Basically I want to always look at only the first 500 records in the table post-refresh (Rows 9 to 508).
Any help much appreciated!
Baker