+ Reply to Thread
Results 1 to 4 of 4

Help: Need to find oldest date based on a location

  1. #1
    Registered User
    Join Date
    12-08-2006
    Posts
    5

    Help: Need to find oldest date based on a location

    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:

    Please Login or Register  to view this content.
    And so on...
    and on another tab I have:
    Please Login or Register  to view this content.
    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!

  2. #2
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    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

  3. #3
    Registered User
    Join Date
    12-08-2006
    Posts
    5
    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?

  4. #4
    Forum Expert daddylonglegs's Avatar
    Join Date
    01-14-2006
    Location
    England
    MS-Off Ver
    2016
    Posts
    14,675
    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

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1