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