Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
cheshire191 wrote...
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. Forget MODE. One way to find the k_th most frequent number in the range rng is =INDEX(rng,MATCH(LARGE(FREQUENCY(rng,rng), k ),FREQUENCY(rng,rng),0)) |
#3
|
|||
|
|||
See my post in:
See: http://www.mrexcel.com/board2/viewtopic.php?t=159292 cheshire191 wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Arithmetical Mode Value for Filtered cells in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
Mode Function with Criteria | Excel Worksheet Functions | |||
Allowing events/macros during formula mode? | Excel Discussion (Misc queries) | |||
Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
coverting answer from Radian mode to degree mode | Excel Worksheet Functions |