Results 1 to 5 of 5

Min/Max Matching Between Ranges

Threaded View

  1. #1
    Registered User
    Join Date
    10-27-2010
    Location
    Gambrills, MD
    MS-Off Ver
    Excel 2007
    Posts
    3

    Min/Max Matching Between Ranges

    I have a worksheet that's been baffling me for some time now.

    I have 2 sheets (see below)

    Sheet 1:
    Name | MIN Start Date | MAX End Date

    Sheet 2:
    Name | Start Date | End Date

    Named Ranges:
    _Est_End_Date_Active_Column (range of all end dates)
    _Start_Date_Active_Column (range of all start dates)
    _Assignment_Active_Column (range of all names)

    What I want to do is match the MIN Start Date where Sheet 1 Name is in the row.

    So for example:

    Data:
    Jason | 1/1/11 | 2/15/11
    Tommy | 2/2/11 | 3/15/11
    Justin | 3/3/11 | 4/15/11
    Sal | 4/4/11 | 5/15/11

    Sheet 1:
    Justin | 1/1/11 | 2/15/11

    What I am getting is:

    Justin: 1/1/11 | 5/15/11

    Here's the formula I've been working with:

    =MAX(IF(_Assignment_Active_Column=$A14,_Est_End_Date_Active_Column))

    Not sure what I am doing wrong...
    Last edited by NBVC; 07-11-2011 at 02:42 PM.

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