0

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.

Ben Krahe
  • 1

1 Answers1

1

Try-

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

enter image description here

Harun24hr
  • 30,391
  • 4
  • 21
  • 36