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

Welcome. Glad it worked. Pl spare a moment to press the YES button (like the
one below) in that response.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Ben" wrote:
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

Hi Max,

I now need to count how many clients are repeated in my record sheet. If
clients have a unique client number how do I work out how many clients
received a service on more than one occassion?

"Max" wrote:

Welcome. Glad it worked. Pl spare a moment to press the YES button (like the
one below) in that response.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Ben" wrote:
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

Pl start a fresh, new thread for your new query.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---