I would like a script for detection of �outliers� during data anaylsis and
removal as a second step.

I have a range of cells containing �control� values and specific cells
containing the �outlier� limit values (high/low, e.g. +/- 2 SD from average).
i.e. the range that valid data should be within.

I would like to run a script that checks if any of the �control� values are
outliers and then deletes them.
Deletion of outliers should be limited to e.g. 2 values.
The script should only run once.

I can not use �conditional formatting� since the �outlier� limit values
change when deleting values, the formatting will follow and possible create
new outliers.

I hope my description is good enough.

Anybody with input to something like this?

- Btw, I'm running Win2k, Excel 2002 SP3.

"Viggo Linde" wrote:

> I would like a script for detection of �outliers� during data anaylsis and
> removal as a second step.
>
> I have a range of cells containing �control� values and specific cells
> containing the �outlier� limit values (high/low, e.g. +/- 2 SD from average).
> i.e. the range that valid data should be within.
>
> I would like to run a script that checks if any of the �control� values are
> outliers and then deletes them.
> Deletion of outliers should be limited to e.g. 2 values.
> The script should only run once.
>
> I can not use �conditional formatting� since the �outlier� limit values
> change when deleting values, the formatting will follow and possible create
> new outliers.
>
> I hope my description is good enough.
>
> Anybody with input to something like this?
>