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:
And so on...
and on another tab I have:
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!
Bookmarks