ExcelBanter - Multiple entries last date

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Multiple entries last date (https://www.excelbanter.com/excel-worksheet-functions/217590-multiple-entries-last-date.html)

Simo

Multiple entries last date

Hi All, I have a column of customers with their corresponding visit date. I
need to find the last time I visited each customer.

Customer Date
A shop 1/1/9
A Garage 2/1/9
An Office 2/1/9
A Garage 5/2/9
A shop 5/2/9

etc.

Any helpmost appreciated

Mike H

Multiple entries last date

Hi,

The dates look to be sorted so try this

=LOOKUP(2,1/(A2:A1000=A2),B2:B1000)

It will return a number which you must format as a date.

Mike

"Simo" wrote:

Hi All, I have a column of customers with their corresponding visit date. I
need to find the last time I visited each customer.

Customer Date
A shop 1/1/9
A Garage 2/1/9
An Office 2/1/9
A Garage 5/2/9
A shop 5/2/9

etc.

Any helpmost appreciated

All times are GMT +1. The time now is 03:06 AM.