assuming you are dealing with 12 months of data in row 1 - put this formula
in M1

=OFFSET(M1,0,MATCH(9.99999999999999E+307,A1:L1)-COLUMN(M1))/OFFSET(M1,0,MATCH(9.99999999999999E+307,A1:L1)-COLUMN(M1)-1)-1

The issues with this formula a 1) any text values in cells A1:L1 will
give you an error, 2) the formula finds the LAST value in the 12 cells and
divides it by the cell to the immediate left. If that cell is empty - divide
by zero error.


"chewmanfoo" wrote:


Genii,

I need a way to have a cell at the end of a row that shows the % change
of the last two cells (with data in them) in a row. Imagine if you had
sales figures in a row, one column for each month. I need a column on
the right with the % change between the last two cells in that row -
like "Sales was up 21.6% from March to April". This formula has to
automagically adjust, only giving the % change opf the last two cells
in the row with data in them.

Does that make sense? Is it possible?

How is that done?


--
chewmanfoo
------------------------------------------------------------------------
chewmanfoo's Profile: http://www.excelforum.com/member.php...o&userid=27112
View this thread: http://www.excelforum.com/showthread...hreadid=466251