Find largest absolute value

[maxyoursandals]

I have 3 columns each with different numbers positive or negative. I need to find/return the larfest value of the three and return

 

[AhoyNC]

Maybe something like this.

Book1
	A	B	C	D	E
1	110	-27	127		250
2	17	156	185
3	138	-5	35
4	81	49	107
5	168	-250	63
6	151	-15	-60
7	19	153	197
8	-48	94	189
9	166	6	52
10	-34	15	16
11	100	199	120
12	16	190	196
Sheet1

Cell Formulas
Range	Formula
E1	E1	=MAX(ABS(A1:C12))

 

[Fluff]

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)

 

[maxyoursandals]

Edit, accidentally posted:


I have 3 columns each with different numbers, positive or negative. I need to find/return the largest value of the three and keep the sign (+ or -). I tried

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)

On mobile so accidentally posted twice. What I meant to say is I have 3 columns (A1:C1) of positive and negative numbers. I want to return the highest value of the three in cell D1 with the sign intact.

I previously tried a choose match large function but it obviously only returns positive numbers.

 

[Fluff]

Ok how about

+Fluff v2.xlsm
	A	B	C	D
1	-20	-9	-5	-20
2				-20
Main

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)

 

[maxyoursandals]

Ok how about

+Fluff v2.xlsm
	A	B	C	D
1	-20	-9	-5	-20
2				-20
Main

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)

This works perfectly. Thank you.

 

[Fluff]

You're welcome & thanks for the feedback.