I have columns of data (marks on assessments) that filter in various ways. When I filter I simply hide the rows that do not match the filter key. Then I want do stats on the visible data, eg averages, Standard Deviations etc. However Excel seems to include the hidden rows when I this. Is there a way to get Excel to ignore hidden rows in its calculations?
I could just copy the data on the visible rows to another worksheet, do the stats there and then copy it back to the appropriate cells but if there is a built in method I would like to know.
Thanks
I could just copy the data on the visible rows to another worksheet, do the stats there and then copy it back to the appropriate cells but if there is a built in method I would like to know.
Thanks