Hello,
I am trying the get the largest value, positive or negative, from an array.
e.g. (-1.27, #VALUE!, 0.12, -0.54)
For the above case I want the answer to be -1.27.
I have used the following formula however I keep getting an error.
=INDEX(C66:F66,MATCH(AGGREGATE(4,6,ABS(C66:F66)),ABS(C66:F66),0))
For some reason the ABS function in the AGGREGATE function doesn't work.
Any solutions??
I am trying the get the largest value, positive or negative, from an array.
e.g. (-1.27, #VALUE!, 0.12, -0.54)
For the above case I want the answer to be -1.27.
I have used the following formula however I keep getting an error.
=INDEX(C66:F66,MATCH(AGGREGATE(4,6,ABS(C66:F66)),ABS(C66:F66),0))
For some reason the ABS function in the AGGREGATE function doesn't work.
Any solutions??