View Single Post
  #1   Report Post  
cheshire191
 
Posts: n/a
Default Mode() & Large()

Ok .. i know how to return the number used most in a range;

=MODE(A1:A15)

and i know how to find the K-th largest number;

=LARGE(A1:A15,k)

but what i can't figure out is how to find the 2nd or 3rd most used number.
basically i need to combine the 2 functions.

any help .. please, thanks in advance.