View Single Post
  #1   Report Post  
Michael J
 
Posts: n/a
Default how to exclude data outliers from formula or chart without deleti.

I have a data set with some outliers (blunders usually) that I want to
temporarily exclude from formula or charts. I would like a way of
"locking-out" these data cells. I could selectively skip over them but this
is sometimes cumbersome. I need a way to toggle them in or out depending on
my analysis.