Microsoft Office Help

[Doc Holliday]

Didn't see a thread on this in search, so starting one now.

EXCEL: Functions - I need a function to find the most common entry in a column, like MODE() but for text.


Example:

APPLES
BANANAS
BANANAS
ORANGE
APPLES
BANANAS

= BANANAS


Go!

[Razor Ramon]

This isn't advice, but I hate Excel. It's an annoying spreadsheet program. You're also better off googling a how-to guide.

[bandit]

Doesnt it bring up the word so as long its in the same column?

[Doc Holliday]

This isn't advice, but I hate Excel. It's an annoying spreadsheet program.

Why? Does Mozilla make a spreadsheet app?

Doesnt it bring up the word so as long its in the same column?

I have a thousand rows, need to find the most common value and MODE() doesn't work on cells with text, numbers only.

You're also better off googling a how-to guide.

But I like TNL. We have need to know threads on other caca, why not start one on this? If we get a lot of requests, I'll organize the first post with all the tricks by program/category.

[Razor Ramon]

Not saying it isn't a good idea so that others can familiarize themselves with the program in case the need ever pops up, but if you want a faster answer Google is the winner.

I had to use this back in high school and forgot all the tricks to it. I can't even get two cells to add up.

[Netwurked]

Have you tried using Pivot Tables Doc?

[Yoshi]

If you know all of the values in the column, a COUNTIF would work. For example...

=COUNTIF($A$2:$A$100,"BANANAS") would return 3, while the others would only return 1. You can also dynamically link the last argument instead of hard coding it.