| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Mode for Non-Numbers
How can I return the most frequently occurring text entry that fits a given
critiera? E.g. __A__ __B__ Atlanta John Atlanta John Atlanta Mark Atlanta John Boston Mark Boston John Boston Mark Boston Mark Boston Mark I would like to be able to return IF(A=Atlanta,Mode(B)) = John. Thanks. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| 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 | Excel Worksheet Functions | |||
| Combo Box goes to edit mode even if design mode is in OFF position | Excel Discussion (Misc queries) | |||
| coverting answer from Radian mode to degree mode | Excel Worksheet Functions | |||
Threaded Mode
