Formula to retrieve most frequent number
I believe I'd use MODE for this in Excel but can't find an equivalent in Smartsheet. I need to build a formula to retrieve the most commonly found numbers from a column in a referenced sheet. Does anyone have a suggestion for how this can be done without MODE?
For example, if I have a column in another sheet that includes the following numbers, each in their own row:
The formula would produce "19-001". I would really love to avoid exporting to Excel as this is a metric we'd like to display on a Smartsheet dashboard.
Help Article Resources
Check out the Formula Handbook template!