Maximum value
Another way
(array entered.)
=INDEX(H1:H100,MIN(IF(ABS(H1:H100)=MAX(ABS(H1:H100 )),ROW(H1:H100))))
If this post helps click Yes
---------------
Jacob Skaria
"Masha" wrote:
hei,
I have a table like:
Fx Fy Fz
1 -1975 -3211 -1321
2 781 -5419 1175
3 1431 1270 -4184
4 -8191 6251 -6000
I need to have an answer for the maximum absolut value with keeping the
sight if it is negative.
Like:
Max (+/-) -8191 6251 -6000
is it possible?
|