Mode Function Using Text

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

Guest

I can use mode with numbers no problem. I need help with text. I have one column with approximately 1000 entries of company names. I would like to see which company's name is listed the most in that column, which company is the second most and so on. How do I write a formula to return this information without assigning numbers to each different company name

I found some info on this site already, but the suggestions did not work.
 
This works -- ctrl/shift/enter
=INDEX($A$1:$A$1000,SMALL(IF(ROW($1:$1000)*(MATCH($A$1:$A$1000,$A$1:$A$1000,
0)=ROW($1:$1000))=0,"",ROW($1:$1000)*(MATCH($A$1:$A$1000,$A$1:$A$1000,0)=ROW
($1:$1000))),ROW(A1)))
and fill down.
Assumes company names are in A1:A1000

bosox5fan said:
I can use mode with numbers no problem. I need help with text. I have
Click to expand...
one column with approximately 1000 entries of company names. I would like
to see which company's name is listed the most in that column, which company
is the second most and so on. How do I write a formula to return this
information without assigning numbers to each different company name.
 
Thanks, but I must not be using it right. I am by no means an expert at this stuff. The column my company names are in is "G" and the names start at row "3". Should I replace all the "A"'s with "G"'s and "1"'s with "3"'s. I did this and then control-alt-delete and it does not enter as a formula, but as regular text. Any idea on what I am doing wrong?
 
Back
Top