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

M

Michael J

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.
 
D

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.
 
A

AlfD

Hi!

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

Alf
 
Top