I have attached an excel file. I am trying to move the information of the last 30 rows of table 1 to be displayed into table 1. In table 1 I only want to display these last 30 rows and would like for it to update automatically as table 2 is modified. I also have some equations that calculate Standard deviation and averages for these last 30 values but, it does not seem to exclude zero or empty cells, how can I fix this? For these equations I want only the last 30rows to be considered and only the non-zero values of within these 30 rows.
Bookmarks