This works in row 5

=OFFSET(C5,0,MATCH(9.99999999999999E+307,C5:N5)-1)/OFFSET(C5,0,MATCH(9.99999999999999E+307,C5:N5)-2)-1



"chewmanfoo" wrote:


That formula works fine for columns A-L, but my formula needs to be
C5-N5, so I can't figure out how to transpose it. I think one of the
values in the formula specifies an offset, but which one.

I'm using this formula:

=OFFSET(O5,0,MATCH(9.99999999999999E+307,C5:N5)-COLUMN(O5))/OFFSET(O5,0,MATCH(9.99999999999999E+307,C5:N5)-COLUMN(O5)-1)-1

I spent a half an hour in Excel Help trying to figure this out, nogo.

Can you tell me how to transpose it?

TIA,
chewmanfoo


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