Thread: Formula to find most recent column of data

Greetings, all:

I have a spreadsheet where I summarize data monthly. I have the months in columns. Each month, I add a column full of data. On another sheet, is the most recent month's data. For example:

On SHEET1
         Jan    Feb   Mar   Apr   May
A        14      14     23
B        14      13     22
C        14      14     23

On SHEET2
        Mar
A        23   
B        22   
C        23

What I am looking to do is automatically fill SHEET2's data based on the right-most column of data. When I put information in for April, I would like SHEET2 to automatically update with April's data. I can do this in VBScript easily enough but then I have to maintain the VBScript along with all of the signing or macro warnings.

What is a formula to put into SHEET2's data columns to get the most recent month of data?

Thanks!

Thanks for the reply and hint.

It does not seem to be working for me, though. I'm getting the first column with data, not the last. In my sample data, I am getting January, not March. Adding April data has no effect.

I'm still working with the formulas. I think this is pointing me in the right direction but is not quite there yet.

Thanks! I appreciate the quick response!

A profound thanks.

Now, I have to look through what I typed and determine where I fat-fingered it. It is working perfectly now, exactly as you had originally stated.

Thank you