Finding the mode of text

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Try the following...

=INDEX(A1:A10,MODE(MATCH(A1:A10,A1:A10,0)))

Hope this helps!
 
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!
==============================================



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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error on text wrap pivot table 1
Mode function in excel using Text 5
How to look up and pull text from another wkst 1
Automatically Enter Formula in a Cell After Entering Data in Another Cell 0
Excel Columns moving up and down on their own in a worksheet. What Goes? 2
Formula Audit mode active in one column only; cannot kill. 2
Mode Function or MODE Function -- Can't get it to work!! 4
Getting Text data using the Data - Subtotal feature 1

Back
Top