| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel "mode" function returns different results based on sort orde
I am using "mode" in Excel to return the most common numeric value in a
questionnaire field. One domain contains two equally-represented values ("1" and "2")."Mode" returns a value of "1" if the list is sorted in ascending order, and returns "2" if the list is unsorted. I can find no detail from our cretinous friends at Microsoft as to why this might be so. Any insights would be appreciated. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| sorting data on protected worksheet | Excel Discussion (Misc queries) | |||
| Sort order : Excel vs imported data | Excel Discussion (Misc queries) | |||
| "Group" function very slow with Excel 2003 :( ... While very quick with Excel2000 :O) | Excel Discussion (Misc queries) | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
| Data > Sort function amnesia? | Excel Discussion (Misc queries) | |||
Threaded Mode
