Skip to main content

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!

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?


Reply