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