hi
I have some spreadsheets which have calculation sections a couple of rows after the last row of data. The calculations are based on only visible cells, so when autofiltering, things like Profit & Loss and Strike rate are displayed. Depending on how I filter, though, sometimes the cells disappear and I like to stop it from happening.
Here is a screen shot of what I am talking about
Can anyone suggest a way to not have these cells disappear, regardless of what I filter for? Currently they can disappear if I am filtering a column/s nowhere near these
cheers
I have some spreadsheets which have calculation sections a couple of rows after the last row of data. The calculations are based on only visible cells, so when autofiltering, things like Profit & Loss and Strike rate are displayed. Depending on how I filter, though, sometimes the cells disappear and I like to stop it from happening.
Here is a screen shot of what I am talking about
Can anyone suggest a way to not have these cells disappear, regardless of what I filter for? Currently they can disappear if I am filtering a column/s nowhere near these
cheers