Question description:
This user has given permission to use the problem statement for this
blog.
I have 2 sheets:
Sheet A: I have Dates in 1 Column (A1:A10)
Sheet B: Date will be show in B1: (query what is in A1 in Sheet A)
I'm searching for a query formula to get always the last entry (A1:A10) Is there any possibility to show the last entry from Sheet A (A1:A10) which one has a Date in there?
Solved by O. Q. in 11 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/10/2017 - 11:43
Welcome, thank you for choosing Got It Pro-Excel! I'll be glad to assist you with your concern.
Excelchat Expert
29/10/2017 - 11:44
I understand you need a formula to get the last entry on 1 sheet to be shown on another sheet. May you please provide the sample data so I can help you with your concern?
User
29/10/2017 - 11:44
sure i'll do this one second
Excelchat Expert
29/10/2017 - 11:44
Thank you :)
User
29/10/2017 - 11:46
so in sheet 1 is the range (A1:A10) with dates and in Sheet 2(A2) should be the last entry of Sheet 1 A1:A10
User
29/10/2017 - 11:47
in this case the 3rd entry but if i#m adding 1 date it should show the 4th in Sheet 2 (A2)
Excelchat Expert
29/10/2017 - 11:47
So you only need to get the last entry in column A in Sheet 1 correct?
User
29/10/2017 - 11:47
correct
User
29/10/2017 - 11:48
i tried this with the query formula but didnt get it :(
Excelchat Expert
29/10/2017 - 11:48
Alright, please give a moment to solve your problem. Thank you!
User
29/10/2017 - 11:48
sure :) thank you!!
Excelchat Expert
29/10/2017 - 11:53
To resolve your problem, we use the following formula: =LOOKUP(1,1/(Sheet1!A:A<>""),Sheet1!A:A)
User
29/10/2017 - 11:53
AWESOME!
Excelchat Expert
29/10/2017 - 11:53
it should give you the last entry in Column A Sheet1 :)
User
29/10/2017 - 11:53
Thank you so much!
Excelchat Expert
29/10/2017 - 11:53
You're welcome. Is there anything else that I can assist you with regarding this issue?
User
29/10/2017 - 11:54
so if i wanna shrink that to A1:A10 i should change the "Sheet1!A1:A10<>"" right?
Excelchat Expert
29/10/2017 - 11:54
Yes you are right :)
User
29/10/2017 - 11:54
awesome :) this helps so much! Great service!!
Excelchat Expert
29/10/2017 - 11:54
Thanks for using Got It Pro-Excel. Please give your kind feedback for our service. Have a good day! :)
This is the output file from the real Excelchat help session:
This is an example of the expert help you can get. It contains no private user
information.
