Thread: How to retrieve data in right column of data?

Hello,
I'm a newbie to this site and forum. I've been using what I've discovered is very little of Excel's capabilities for years, and am just starting to explore the wide range of features and need a little help.

Here’s where I need help… I have 13 columns of data; each column heading is a different month and the data is whole numbers or dollars. Several individuals are responsible for adding updates each month. Is it possible to have or how do I set up a column to the right of the data to show the most recent data which would be located to the right of the previous months data each month.

This most recent is used to automatically update charts at the top of my worksheet.

Thanks very much for any suggestions you have!

TS

Originally Posted by tscott

Hello,
I'm a newbie to this site and forum. I've been using what I've discovered is very little of Excel's capabilities for years, and am just starting to explore the wide range of features and need a little help.

Here’s where I need help… I have 13 columns of data; each column heading is a different month and the data is whole numbers or dollars. Several individuals are responsible for adding updates each month. Is it possible to have or how do I set up a column to the right of the data to show the most recent data which would be located to the right of the previous months data each month.

This most recent is used to automatically update charts at the top of my worksheet.

Thanks very much for any suggestions you have!

TS

I suppose you have data in column from col A to M starting from row 5
put in N5

=LOOKUP(2,1/(A5:M5<>""),A5:M5)
it will return most recent data entered in column A to M

Regards.

PERFECT!

Well Almost, but it's my fault...

While applying this to several different sections, I realized that I have some negative numbers in my data that results with a zero.

Is it possible for a return of negative or positive numbers?

Thanks very much!

it returns any value (negative, positive or any text), there may be other problem with referring to different cells. check it.

It's working. I don't know what I did that made it return 0's but it's all good now.

Thanks again!