Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Finding the mode of text
I have a worksheet with several columns that are data validated text. I want
to find out which of the entries is used the most and have that entered into the last cell of the column. With numbers, I just used the mode function. Can I do find the mode of text? Thanks |
#2
|
|||
|
|||
Try the following...
=INDEX(A1:A10,MODE(MATCH(A1:A10,A1:A10,0))) Hope this helps! In article , "RoterRuter" wrote: I have a worksheet with several columns that are data validated text. I want to find out which of the entries is used the most and have that entered into the last cell of the column. With numbers, I just used the mode function. Can I do find the mode of text? Thanks |
#3
|
|||
|
|||
If there's a possibility that you might have blank cells in your range, try
this *array* formula: =INDEX(A1:A100,MATCH(MAX(COUNTIF(A1:A100,A1:A100)) ,COUNTIF(A1:A100,A1:A100), 0)) Array formulas are entered using CSE, <Ctrl <Shift <Enter, instead of the regular <Enter, which will *automatically* enclose the formula in curly brackets, which *cannot* be done manually. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "RoterRuter" wrote in message ... I have a worksheet with several columns that are data validated text. I want to find out which of the entries is used the most and have that entered into the last cell of the column. With numbers, I just used the mode function. Can I do find the mode of text? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sort or Filter option? | Excel Worksheet Functions | |||
Finding Duplicated Text within Columns | Excel Discussion (Misc queries) | |||
Read Text File into Excel Using VBA | Excel Discussion (Misc queries) | |||
Finding Partial Text in a Cell | Excel Worksheet Functions | |||
Macro or Function to make text size to suite text Length? | Excel Discussion (Misc queries) |