Hi,
I'm new in the forum. Hopefully I posted my question in the right location box.
I'm looking for a formula to get the last data entered
e.g. Row1 to Row 5 if I changed the data on Row 3 the return value will show the data of row 3.
I'm using formula: =INDEX((column),COUNTA(column)) ----the result value is only returning Row 5 data.
Thank you for your help.
Last edited by AliGW; 10-30-2019 at 01:19 PM.
Welcome to the forum.
In order to timestamp entries, you'll need VBA - is this what you mean? In other words, you want Excel to know which your most recent entry was?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Hi Ali,
yes, you read my mind and appreciate your help.
I was hoping it will not be a VBA since I'm not really familiar with that.
Will that be the only work around?
I believe so -sorry. Let's get this moved to the VBA section and see what happens.
There are plenty tutorials depending on what you need. Eg: https://www.spreadsheetsmadeeasy.com...nged-with-vba/
Click the * to say thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks