Hi, I have 2 columns of numbers A and B, how do I return the max absolute value in column B when I lookup a value from column A?
For example, I want to lookup 2 to return the max absolute value is which 100 and 1 to return -10 and 5 to return 40 etc.
Thanks for your help!
A B
1 -10
1 -5
1 0
1 4
1 6
2 10
2 100
2 -50
2 -5
2 10
5 -2
5 40
5 -9
5 -10
5 -3
Bookmarks