MAX applied to dynamic array

[excelos]

Hello

Do you know any neat way to apply a MAX in an array?
I.e. MAX({0,3},2) will return 3
While, I wanted to return {2,3} i.e. to compare each of the {0,3} vs 2 and return the resulted array.

It would be great to do the same with substituting text, i.e. replace b with e in each of the {abc,bcd} to return {aec,ecd}

I think both the above kind of represent a more general concept: how to perform actions on each of the components of an array with a constant value without having to repeat the constant value to create an equally long array.

Thanks!

 

[StephenCrump]

Have you tried the second one?

=SUBSTITUTE({"abc","bcd"},"b","e") works fine.

Functions like MAX, AVERAGE, SUM etc will collapse the array to a single value, so you'll need a workaround, e.g.

=LET(n,{0,3,9,-1,2,22,5,1},IF(n>2,n,2))