Stuck try to figure out a formula

[kuhrty]

I am trying to use the offset and max function, I need to get the last
value in a row of data but from a column prior to the data.

Example:
Column A ColumnB ColumnC ColumnD
ColumnE
Past Due Jan09 Feb09
Mar09 Diff
Row1 30 Days 100 200
150 50
Row2 60 Days 200 100
125 (25)
Row3 90 Days 50 150
200 (50)

I want to capture ColumnD of row 1

I have attempted these formula's
=OFFSET(A1,1,0,COUNT(1:1),1)
=OFFSET(A1,1,0,MAX(5:5),1)

Any help is graetly appreciated.

 

[Shane Devenshire]

Hi,

Try this

=OFFSET(A2,,COUNT(2:2)-1)

I am assumig you have titles on row 1.