Hi, is there a way to lookup the largest number in a column but treating the negative number as a positive number?
Something like Max and Min but I want the largest absolute number between them.
Please see the attached example, in N41, i want it to show -10 instead of 5 and the depth beside it to show 22 instead of 8.
Thank you
Last edited by xWiZardx; 12-17-2010 at 08:10 AM.
Hi
Both of these are array entered (ctrl, shift, enter)
N42: =MAX(ABS(M13:M41))
O42: =INDEX(A13:A41,MATCH(N42,ABS(M13:M41),0))
HTH
rylo
Ok it works, but can it still show the negative sign? instead of 10, i would like it to show -10
Thanks a lot
An alternative:
Please Login or Register to view this content.
My Recommended Reading:
Volatility
Sumproduct & Arrays
Pivot Intro
Email from XL - VBA & Outlook VBA
Function Dictionary & Function Translations
Dynamic Named Ranges
It works, thanks for that.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks