Multiple entries last date

  • Thread starter Thread starter Simo
  • Start date Start date
S

Simo

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
 
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
 
Back
Top