| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I calculate the mode for a column of text?
Hi there,
I am trying to determine the most frequently occurring (mode) text entry but my understanding is that the mode function is only used for numeric data? I have a large dataset which lists sickness reasons and I would like to find out the mode and return the text value to cell J163. In the example below the mode would be "vomiting", please can anyone help, would be most appreciated, thanks Matt e.g Col J Vomiting Vomiting Flu symptoms Flu symptoms Flu Stomach upset Withheld Vomiting Sickness vomiting |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Mode for Text | Excel Worksheet Functions | |||
| Mode for Text | Excel Discussion (Misc queries) | |||
| Calculate mode | Excel Discussion (Misc queries) | |||
| Calculate mode based on criteria | Excel Worksheet Functions | |||
| How do I calculate the mode of a column of IP addresses? | Excel Worksheet Functions | |||
Threaded Mode
