CODEWITHSUNDEEP
exceldeviation
Ben Krahe
Ben Krahe

Reputation: 1

Standard Deviation of certain cells in excel

for eg I have 5 numbers in excel, in A1,A2 etc numbers could be 95 99 98 96 97, (not sorted). How do I get the standard deviation for the top 4 numbers only (ie: dropping the lowest number) Thanks in advance.

Upvotes: 0

Views: 41

Answers (1)

Harun24hr
Harun24hr

Reputation: 36870

Try-

=STDEV.S(FILTER(A:A,A:A>SMALL(A:A,1)))

enter image description here

Upvotes: 1

Related Questions