98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View Reviews
Forum home » Delegate support and help forum » Microsoft Excel Training and help » Last?
Last?
Resolved · Low Priority · Version Standard
Tue 12 Feb 2008, 16:47Delegate Nick said...
Nick has attended:
Access Introduction course
Last?
Hi
I have a set of data running in a row that I add to every month - in column A I have a return field (which is used as a link elsewhere) where I want to capture the last value in the row automatically without having to manually update each month when new data is added to the end of the row - is there a "last" function or something where I can automatically pick up the last value in the row automatically each month when data is added to the end of the row??
Cheers
NICK
Sat 23 Feb 2008, 19:32Trainer Mara said...
RE: Last?
Hello Nick,
I hope you enjoyed your Access training with us, and thank you for your question. This was a great question, and I'm pleased to say that what you want to do is indeed possible in Excel. Here's the formula you would need, if you want to reference the last cell in column A:
=INDIRECT("A"&COUNTA(A:A))
To reference column D, the formula would change to:
=INDIRECT("D"&COUNTA(D:D))
I hope this resolves your question. If it has, please mark this question as resolved. If you require further assistance, please reply to this post. And please feel free to ask any other questions you may have.
Have a great day.
Regards,
Mara
Microsoft Office Specialist Master Trainer
Mon 25 Feb 2008, 09:42Delegate Nick said...
RE: Last?
Mara
Thanks for the response. The formula you gave me above returns the "count" of a particular column, what I need is the last value returned (i.e. say column A has data down to row 60, the value in A60 is
Sat 1 Mar 2008, 20:23Trainer Mara said...
RE: Last?
Hi Nick,
Are you sure you have entered the formula exactly as I gave it? It shouldn't give you a count, but rather, should give you the value in the last cell in the column.
I have tried to adjust the formula to work with rows instead of columns, but haven't had luck with it. I think this is because Excel expects data to be added moving downward rather than to the right. Would it be possible for you to transpose the data moving forward, and have it added to a new row every time?
Regards,
Mara
Training information:
See also:
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Jumping Between Sheets in a BookPgDn and PgUp keys scrolls up and down a screen page in most applications. |
