one way
=OFFSET(H2,MATCH(9999999,H2:H21)-1,0)/OFFSET(H2,MATCH(999999,H2:H21)-2,0)

--
Don Guillett
SalesAid Software

"chewmanfoo" wrote
in message ...

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