Thanks Harlan and Bernie.

Both formulas worked perfectly. I can't believe how fast you were to answer
and solve my problem. I have stared and experimented on
this spreadsheet for 2 hours trying to get the correct answer and you guys
did it in 5 minutes.....gee

"Bernie Deitrick" wrote:

Thanks, Harlan, I zoned on that.

=IF(MAX(A1:A3)ABS(MIN(A1:A3)),MAX(A1:A3),MIN(A1:A 3))

might be simpler for a novice to understand / maintain.

Bernie
MS Excel MVP


OP stated he needed the sign for negative results. Your formulas only
return absolute values, so no signs.

"Ravager" wrote in message
I need to know if there is a way to find the largest change in a single
column of numbers, even if they are negative values.
...
Every function I use returns 135.67 as the largest but I need to return the
-256.77, (and show the negative sign). This is a very simple example but I
...

Try

=LOOKUP(2,1/(A1:A3^2=MAX(A1:A3^2)),A1:A3)