Excel - COLUMN Function Problem - Expert Solution

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

Get instant expert help with Excel and Google Sheets

Post your problem and you’ll get expert help in seconds.

Your message must be at least 40 characters
Your privacy is guaranteed. Your session will not be used for blog unless you give us persmission.

Click here to get your free Excelchat help session

Subscribe to Excelchat.co
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
The Allstate Corporation
United Parcel Service
Dell Inc