Help: Need to find oldest date based on a location

[paindivine]

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!

[daddylonglegs]

So assuming your second table is on sheet 2 with managers in column A and offices in column B then in a third tab, if you have a list of managers from A2 down you can try this formula in B2 copied down for the oldest date

=MIN(IF(ISNUMBER(MATCH(sheet1!A2:A6,IF(sheet2!A2:A4=A2,sheet2!B2:B4),0)),sheet1!C2:C6))

confirmed with CTRL+SHIFT+ENTER

[paindivine]

That doesnt seem to be working for me. It appears to only show the olders order... not the oldest order for that paticular manager. Am I doing something wrong?

[daddylonglegs]

Have you confirmed with CTRL+SHIFT+ENTER?

You need to select cell with the formula, hit F2 and then, hold down CTRL+SHIFT and hit ENTER. Curly braces like { and } should appear automatically around the formula in the formula bar