I am looking for the biggest absolute number in a range.
For example:
-20
3
50
40
I hope to get 20 as a result

I tried max(ABS(D2:D5)) but that does not work.
Of course I can use an intermedite range and fiirst convert all my data to
ABS then do a max - but I hope there is another way.

Many thanks.

Dan