| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mode Function or MODE Function -- Can't get it to work!!
I appreciate everyone's answers, but nothing has worked. I have even copied
the numbers onto a blank worksheet to find the most frequently occurring number in that row using the MODE function. Interestingly, AUTOSUM doesn't work after I cut and paste numbers, so there is something very wrong in my 2007 Excel. If I don't cut and paste, AUTOSUM works. I am unable to get the Mode Function to tell me the most frequently occurring number in Column G from row 1 through 447. I place my cursor just below the last entry in column G. I then insert the function =MODE(G1:G447) and I get N/A references or circular reference error messages. There are no blanks and the entire column G is formatted as numbers. PLEASE help. I've looked everywhere! |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mode function | Excel Discussion (Misc queries) | |||
| Using the mode function | Excel Worksheet Functions | |||
| Help with the MODE function | 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) | |||
Threaded Mode
