The offset function uses the ROW first and then the COLUMN. So, modify the
idea to.

=OFFSET(J2,0,MATCH(99999999999,J2:O2)-1)/
OFFSET(J2,0,MATCH(99999999999,J2:O2)-2)
--
Don Guillett
SalesAid Software

"chewmanfoo" wrote
in message ...

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,MATC
H(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