Trying to get the Mode, or Average if there's no MODE in a formula

Hi Jete,

I tried your formula but unfortunately when I get a result of 1,1,2,2 (2,1,2,1 etc) it always shows 1 as the result. I need it to identify that it's a Multi Mode and so Average the values. It should return 1.5