Formula Help

[sh]

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

 

[Bernie Deitrick]

Steve,

To return the right-most value from row 2 (Assuming your data start starts
in column A and extends to the right) use the array formula (entered with
Ctrl-Shift-Enter):

=INDEX(2:2,1,MAX((A2:L2<>"")*COLUMN(A2:L2)))

HTH,
Bernie
MS Excel MVP