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.
- How can I execute PHP code from the command line?
- Blackjack Capstone Project from 100 Days of Code with Dr. Angela Yu
- How to process tabular data from Oracle PL/SQL function in JAVA?
- PHP append one array to another (not array_push or +)
- SQL string throws "External Name not Defined" error when running in VBA module - Name is defined
- run javascript function on griview pageindexchanging event
- Identify the list that is the odd one out, and find its index from given lists
- Different results for function() and fn(). PHP
- Functional programming with dplyr: column_to_rownames() inside function
- Difference on passing a free function as template argument by value or by reference
- How can I filter and count objects in DJANGO template?
- Powershell Out-Host -paging -or- more to limit output of function
- How do I convert a string to a function reference in JavaScript?
- Turing Machine - Finding k-th element and move it to the front of the tape
- Selecting by Column Names within Function
- C# struct with out parameter
- How to count all objects in an array that match a condition?
- Is there a way to deploy a azure function directly to a storage account with private endpoint
- Unknown error in Haskell that prevents a function from running
- curly-curly braces - why won't this function accept an unquoted variable
- Discrepancy in passing array to function
- What is a "static" function in C?
- Running Azure functions locally gives "No runtime" error after .NET7 upgrade
- Java function (method) available everywhere (global)
- postgres event trigger and function not working
- Cannot access temporary tables from within a function
- Why doesn't it just give the list itself?
- Apply function to list depending on values in another list
- Speed up R function that combines linestrings into a single linestring
- The execution order of the promise according to the return type 2