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.
|