offset formula

[ehsas]

=OFFSET(sheet1!$A$11,COUNTA(sheet1!$A:$A)-sheet1!$E$1,0,sheet1!$E$1,1)

The above formul refers to column.How I can changed it to refers to the row instead of column.Regards,

 

[Barrie Davidson]

If I understand your requirements, this should work:

=OFFSET(sheet1!$A$11,0,COUNTA(sheet1!$A:$A)-sheet1!$E$1,sheet1!$E$1,1)

Regards,

 

[Mark W.]

Barry, this is a duplicate posting... See http://216.92.17.166/board/viewtopic.php?topic=26077&forum=2&3.

 

[Barrie Davidson]

On 2002-10-21 17:01, Mark W. wrote:
Barry, this is a duplicate posting... See http://216.92.17.166/board/viewtopic.php?topic=26077&forum=2&3.

Thanks Mark