2.5 StdDevs
These numbers aren't normally distributed so STDs are the wrong too
for the job.
Say I have these numbers:
0.2
1
3.25
5
17
50
125
500
1250
1500
32505
50000
You need to filter the data - just like John lined out.
If you want a no code solution ask the client to filter the data on
his end.
I still don't understand why you think filtering the data requires
hundreds of lines of VBA.
|