how to exclude data outliers from formula or chart without deleti.

[Guest]

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.

 

[Dave Peterson]

If your data is in columns, maybe just use an additional column and use some
kind of formula:

=if(c2=somesortofoutlier,na(),c2)

Where SomeSortOfOutlier is whatever rule you want.

 

[AlfD]

Hi!

Easy way. Copy the workbook: delete the offending or suspect data. Work
on that.

Alf