| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MODE - Second most frequent value
Hi All,
I would like to find the second (2nd) most frequent value in a filtered single column, using a dynamic named range called "Data". Only the visible cells should be used in the calculation. Can this be done using the named range in a single Formula and the result returned to a single cell? Thanks Sam -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200807/1 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Finding the least frequent value in an array | Excel Discussion (Misc queries) | |||
| Find the most frequent date | Excel Worksheet Functions | |||
| Using Mode in Excel, need more than 1st most frequent number. | Excel Worksheet Functions | |||
| 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
