Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Find the biggest change in values in a list?

How would you find the biggest difference/change in values of a list of numbers in Excel?

An example of what I'm looking for is 1,3,4,5,9,10,11,13

The value I would look for is 4 as this is the biggest difference (between 5 and 9).

Is there a way to do this with a list in Excel?

like image 728
B Geaney Avatar asked Dec 07 '25 08:12

B Geaney


1 Answers

A picture is worth a thousand words? :p

enter image description here

EDIT:

Description added:

As shown in the image, put the formula in =A2-A1 in Cell B2 and then drag it down. Once you have your values, use the Max formula to get the maximum value as shown in Cell D5

like image 175
Siddharth Rout Avatar answered Dec 08 '25 23:12

Siddharth Rout