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