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
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
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
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
