Can anyone help me with this? I'm stumped. The primary problem I'm having here is finding the oldest order based on the manager.

On 1 sheet I'll have:

Office | Order# | DueDate | Status
Hurly     2546      2/05/06    Held
Palto     5486      5/04/06    Pending
Clearw    4158      12/01/06   Pending
Palto     5489      5/08/06    Pending
Hurly     2550      7/03/06    Pending
And so on...
and on another tab I have:
Manager | Office
Jim            Hurly
Tom            Palto
Jim            Clearw
And so on...
The important part being that some managers have 2 or more offices.

And the Result I want is

Manager | Number of orders | % Held | Date of Oldest order

I have tried using Dmin, but that doesn't seem to work. There will be about 200 Managers and about 1000 orders to parse. So Dmin doesnt work for me becuase it wants me to have a little table set up for each one. Or maybe I'm using it wrong? any help would be GREAT!