< Go Back

Get date associated with last entry

For those who are looking for a simple and easy way to get date associated with last entry, you have stepped in right place. Getting a date associated is a little tricky so here is an easy guide for making your learning easier about Excel.

How to get date associated with last entry

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

Description

If you want to associate, a date with the last entry there will be always a data in tabular form. We are using here LOOKUP function here in order to associate the last date.

Example 1

Let’s take a random example.

Figure 1: Get data associated with last entry by LOOKUP function in Excel

In the above figure, we are using:

=LOOKUP(2,1/(C5:G5<>""),C$4:G$4)

Inside out description of this formula:

{FALSE,TRUE,FALSE,FALSE,FALSE}

Here we are looking for the TRUE one. After this a new array is formed which is:

{#DIV/0!,1,#DIV/0!,#DIV/0!,#DIV/0!}

Here 1 is the lookup vector. The lookup value was 2 but here we have the largest value 1 in data.

Note

The above formula we applied in Figure1 gives the real values or the real result vector in the end.

Example 2

There might be sometimes when you have cells with 0 in it. So don’t worry, we have another formula for it. Let’s take a look at a new example to understand better.

Here is the new data in the given table below:

Figure 2: Dealing with blank spaces in order to get associated with last entry

The formula we applied here is:

=LOOKUP(2,1/(C5:G5>0),C$4:G$4)

Important note

The LOOKUP function is not only for large data but also for small data. If you are looking for a number or cell in a list of 100, you can use it too. The LOOKUP function is also used with TEXT, SUM, INDEX and many other functions according to your requirements.

But, for now, who wanted to get date associated with last entry, this is an easy guide. It solves you both problems for a simple data or complex data which have blanks with 0.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California
This blog is one way to figure it out. A 20 minute chat session with an expert is a better way.Get step-by-step guidance on your question

Leave a Comment

avatar