| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
The mode function
I looked up the capability of the mode function and it said that the only
time it should return an #N/A value is when there are not two names, or numbers in a range. I am not sure why but for the given stock market sectors, the function below always returns a #N/A when it should return in this case the name finance. Any suggestions? ComputerandTechnology BasicMaterials Retail-Wholesale Medical Finance Finance IndustrialProducts Utilities Medical Finance =MODE(S832:S841) -- Thank you! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mode Function or MODE Function -- Can't get it to work!! | Excel Discussion (Misc queries) | |||
| Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
| Mkae Mode function return "" instead of #N/A when there is no Mode | Excel Discussion (Misc queries) | |||
| MODE Function | Excel Worksheet Functions | |||
| Mode Function | Excel Programming | |||
Threaded Mode
