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.

Hi!

A comparatively easy, quick way would be to create a new copy of the workbook and delete the outliers. You might want to keep a record of what is deleted, but you can always go back to earlier version(s).

Alf

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.

Michael J wrote:
>
> 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

Hi!

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

Alf