Welcome to the Airtable Community! If you're new here, check out our Getting Started area to get the most out of your community experience.

Mode function or formula (as in mean, median, mode)

2385 1
Showing results for 
Search instead for 
Did you mean: 

Is there any formula or function available in AirTable that calculates the mode of the values in a series? I can see on a grouped view that I can choose to summarize each group by summary, average, median, min, max but I don’t see mode as an option and can’t find anything on this in support or here in this (wonderful!) community.

“Mode” is a calculation that returns the most frequently occurring value in a series.

Specifically, I am trying to highlight records with a value not equal to the mode of a series/group.

Thank you!

1 Reply 1

Hmm, working on a new base today, I struck this same problem. Where I had several dates, and I needed a Mode to grab the most common occurring date. Anyone have a formula solution for finding a mode?