maxyoursandals
New Member
- Joined
- Oct 22, 2020
- Messages
- 4
- Office Version
- 365
- Platform
- Windows
I have 3 columns each with different numbers positive or negative. I need to find/return the larfest value of the three and return
If you want to return the actual value, how about
+Fluff v2.xlsm
F G H I J 1 2 -1 13 -9 -20 3 -14 7 -2 4 -3 2 15 5 -20 -9 -5 6 -3 -19 -1 7 13 -7 -16 8 -7 -3 -1 9 8 12 -3 10 -16 1 18 11 -18 -10 9 Main
Cell Formulas Range Formula J2 J2 =AGGREGATE(14,6,F2:H11/(ABS(F2:H11)=MAX(ABS(F2:H11))),1)
This works perfectly. Thank you.Ok how about
Cell Formulas Range Formula D1 D1 =AGGREGATE(14,6,A1:C1/(ABS(A1:C1)=MAX(ABS(A1:C1))),1) D2 D2 =CHOOSE(MATCH(MAX(ABS(A1:C1)),ABS(A1:C1),0),A1,B1,C1)