Extract date for the last data entered

[BRISBANEBOB]

Hi

I am trying to return a date value against the last data entry in a row that contains duplicate data values and blanks. I have attached an example.

Thanks for any help.

[MarvinP]

Hi Bob,

I've been working on leaning this function. See the attached where the Lookup function finds the last column with data in it. Then Indirect Address gives back the date.

Please Login or Register  to view this content.

Last Column with a Value Lookup.xlsx

[BRISBANEBOB]

Love it! Absolutely love it! And I've worked out how it works so the time you spent learning was time well spent. Thanks for your assistance, it's much appreciated

[AlKey]

Try this

Please Login or Register  to view this content.

Format as Date