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


#1

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!