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 largest value of data set while maintaining the sign (positive or negative).
Right now I have =CHOOSE(MATCH(LARGE(A1:C1,1),A1:C1,0),A1,B1,C1) to return the largest number but it only returns positive values.
Right now I have =CHOOSE(MATCH(LARGE(A1:C1,1),A1:C1,0),A1,B1,C1) to return the largest number but it only returns positive values.