Filtering Error

ndorey

New member
Joined
Feb 28, 2014
Messages
2
Reaction score
0
Points
0
I have a sheet that I have percentiles and averages on the far columns. When I filter the columns out it removes portions of the percentiles and averages. Is there a way to "lock" these cells so that they do not change or disappear?
(ie Filter AD to fire and most of the percentiles disappear). I want everything after columns AD to never change.
OK, I realize that the area I would like to freeze is part of the rows and gets filtered out with the other data. With that being said, is there a way to have the %ages and averages, mean, count, etc on another worksheet and have it recalculate with the filtered data. For example on the data set I filter out Fire, so it is just EMS and then if I go to the other worksheet it reflects the updated calculations. I could then go back to the data set and filter it to weekdays and then when I go to the averages worksheet it recalculates with the new filtered data? (I hope that made sense)
 

ndorey

New member
Joined
Feb 28, 2014
Messages
2
Reaction score
0
Points
0
ok, so subtotal works for most of these that I want to do. I am having trouble finding the median and percentile of filtered results on a second worksheet. Any suggestions?
 
Top