In Google Sheets, how can you find the mode of non-numerical data?
If I want to find the mode of A2:A10, but my values are something like:
Foo
Foo
Bar
Foo
Baz
Bar
Foo
Bar
Foo
, what can I do?
The =MODE() function only takes numerical data, so is there a way to find the most frequent of these values? Thank you!
Solution
Use a MATCH on a MAX(COUNTIF(...)) to a COUNTIF and pass the row position back to an INDEX.
=index(A2:A10, match(max(countif(A2:A10, A2:A10)), countif(A2:A10, A2:A10), 0))
In the case of a tie in frequency, the first in the list that matches the maximum frequency rate will be returned.
- dplyr -- different results using custom function
- Why am I unable to copy and execute a function in C?
- How to get the return value from a thread?
- How to auto-register test cases in a test system?
- Why does a function declared inside a conditionally-executed block appear to exist before the block is entered?
- Why does naming a function expression not make the name accessible within the scope, but still possible to delete?
- Why my function in Javascript is not working?
- How can I get Python to start executing from a specific line of code when the code is first run?
- Cannot understand why pd.Series.map fails with a lambda function
- performance difference between User Defined Function and Stored Procedures
- firebase deploy --only functions overrides existing functions
- How to Prevent Wordpress from Stripping HTML Tags in Excerpt
- My table has a date column. I need a function that flags rows as True within the same group if there are a total of more than n rows within m months
- Pass function argument as data-toggle attribute?
- How get JSON data from inside a function and display it on textfield in swift?
- How do I get the function name inside a function in PHP?
- Overhead in unused code
- How can I call several user_names in the Twitter API?
- how to make a function available at start up in R
- Creating Clock in React
- `static` keyword inside function?
- In Python, what does '<function at ...>' mean?
- How to programmatically determine if the default parameter value was used?
- Unable to create a local function because "can't capture dynamic environment in a fn item"
- Use a bash function inside an 'at' job
- How to use eval() in a function from library with functions which are defined outside of this library?
- How can I execute PHP code from the command line?
- Returning a row of 2D array as comma delimited string given row number
- Is there way to add one more argument to the function(which has var args) with default value without breaking existing calls?
- how to make this function periodic in MATLAB?