Formula Help

[Steve]

I have 12 columns in a spreadsheet. One for every month of the year. As each
month is completed the data for that month goes in that column.

I need a fromula in a specific cell that will return the value of the most
recent column (month) that is filled in. So in July it returns the data for
July but will return the data for August when a value is placed in that
cell.

Any suggestions?

Thank you.

Steve Hubbard

 

[Guest]

Use this:

=offset(B2,0,COUNTA(B2:M2)-1)

Where your month headers are in B1:M1 and your values are in B2:M2 and
everything after the most recent month is blank.

A B C D E....
1 Jan Feb Mar Apr
2 Item1 5 6 8 10
3 Item2

 

[Frank Kabel]

Hi
see your other post