Lookup the Least Frequently Occurring Value

Returning the Least Frequently Occuring Value

The following formula returns the least frequently occurring value from A2:A10...


Note that the formula needs to be confirmed with CONTROL+SHIFT+ENTER. If done correctly, Excel will automatically place curly braces {...} around the formula.

Based on the sample data, the formula returns "D".

Sample Workbook: Download