Hello all ... this is my first post here and let me say that I absolutely love this message board. Everyone seems so helpful. Let me thank everyone in advance for all of your help. Ok ... here is my question/scenario.
I have a single column of data. From this data I am looking to find the Standard Deviation BUT I do not want to include any cells where the value is 1.5x the Average of the column (my average throws out min and max values).
I have scoured the posts and thought I had it on a couple of occasions but no luck yet.
Any ideas?
Rob
I have a single column of data. From this data I am looking to find the Standard Deviation BUT I do not want to include any cells where the value is 1.5x the Average of the column (my average throws out min and max values).
I have scoured the posts and thought I had it on a couple of occasions but no luck yet.
Any ideas?
Rob