Thanks Mx...I couldn't see my first post because I got a time out message so
I didn't know it had been posted.

Thanks again...it works

"Max" wrote:

"Ben" wrote:
how do i do that??

Aha, I'm not sure why you can't see your earlier posting?

Here's the response I posted the

.. One way
Assuming client num is unique, and dates in Sheet2 are real dates
In Sheet1,
In E2, array-entered, ie press CTRL+SHIFT+ENTER to confirm the formula:
=MAX(IF(Sheet2!B$2:B$6=A2,Sheet2!A$2:A$6))
Copy down.

Real dates are numbers, increasing chronologically. Hence the latest date
for any particular client num would simply be its largest associated "date"
number
Any good? hit the YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---