| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
MODE Function
I have a spreadsheet containing 6 cells say with the following values ...
1 2 3 1 2 3 I want to work out the MODE and if there isn't one, then work out an average, but the problem is if there is no mode it displays the first cell value (i.e in the above example that would be 1). Surely this isn't right? Any suggestions gratefully received. Thanks Anita |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing worksheet cells from within a function | Setting up and Configuration of Excel | |||
| Automatically up date time in a cell | Excel Discussion (Misc queries) | |||
| Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions | |||
| Conversion | Excel Worksheet Functions | |||
| HOW CAN I GET OFFICE 2003 EXCEL BASIC TO NEST FUNCTIONS LIKE EXCE. | Excel Worksheet Functions | |||
Threaded Mode
