UPDATED MAXA() not returns maximum numeric value if text is in array, as expected according https://support.google.com/docs/answer/3094016
MAXA Returns the maximum numeric value in a dataset.
- and even sample is with error - returns
#VALUE
, not maximum numeric
Example:
formula MAXA({1;20;300;"#VALUE!";"Google"})
gives 300
but if values 1; 20; 300; #VALUE!; Google
are in cells A9:A13
having array =MAXA(A9:A13)
gives #VALUE!
To reproduce: https://docs.google.com/spreadsheets/d/17yJ33Zx24eC7-n-a7EaR9f9knhlQUaKYHEk2ghzZXAI/edit#gid=1923535662
Where is the problem?