Thread: 2.5 StdDevs
View Single Post
  #12   Report Post  
Posted to microsoft.public.excel.programming
[email protected][_2_] gimme_this_gimme_that@yahoo.com[_2_] is offline
external usenet poster
 
Posts: 236
Default 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.