Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

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

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
All articles Miscellaneous Get Date Associated with Last Entry

Get Date Associated with Last Entry

Figure 1. of Date Associated with Last Entry in Excel.

In order to determine a calendar date corresponding with the last data entry in our Excel sheet, we can used the Excel LOOKUP Function. This article will step through the process.

Generic Formula

=LOOKUP(2,1/(row<>""),header)

Where row is the total range of cells containing the data entries and header is the range of cells containing the headers for the columns used in our worksheet.

How to use the Excel LOOKUP Function.

We are now going to demonstrate the usage of the Excel LOOKUP Function in the following three simple steps;

  1. Collect and arrange the data values in our Excel sheet. In the example illustrated below, we are working with sales entries along with corresponding calendar dates.

Figure 2. of Sales Records with Calendar Dates.

  1. For us to obtain the date associated with the last entry in our worksheet, we will enter the following formula into the formula bar for cell G2 in the example illustrated below.

=LOOKUP(2,1/(B2:F8<>""),B$1:F$8)

Figure 3. of LOOKUP Function in Excel.

The formula will lookup the specified range of cells containing the calendar entries and automatically return the calendar date associated with the last entry.

  1. Modify and copy the formula above into the other cells in the LAST ENTRY column of our worksheet, to get the desired results.

Figure 4. of Date Associated with Last Entry in Excel.

Note

  • Our LOOKUP value = 2, and the largest value in the LOOKUP range is 1. Hence the LOOKUP Function will match the last 1in our specific cell range.

Instant Connection to an Expert through our Excelchat Service

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

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

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc