DISTINCTCOUNT

I think it is high time we had #distinctcount in Excel functions similar to Dax. It might also have other arguments like array functions where you choose to count [unique] (appearing once in the array) or [distinct] (appears at least once in the array)  values. Counting distinct should be default behavior.

Other options might be to count only numbers or only text, whereas default behaviour would count all types of values.

Thanks in advance