+ Reply to Thread
Results 1 to 3 of 3

Index and Match Dates and Values

  1. #1
    Registered User
    Join Date
    04-06-2009
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    34

    Index and Match Dates and Values

    See my attached spreadsheet. I am trying to get start dates and end dates based upon rates.

    The first start date is really simple, I just use A2.

    In F2 should return the last date from A2:A27 where the rate is I2

    In E3 The I would like to return the first date in A2:A27 where the rate is G3

    and so on. If the rate is 0 then the date can be blank or 1/1/1900

    Can someone please help?

    Thank you!
    Attached Files Attached Files
    Last edited by katja328; 01-11-2010 at 10:46 AM.

  2. #2
    Valued Forum Contributor rwgrietveld's Avatar
    Join Date
    09-02-2008
    Location
    Netherlands
    MS-Off Ver
    XL 2007 / XL 2010
    Posts
    1,671

    Re: Index and Match Dates and Values

    F2 =MAX(IF($B$2:$B$100=$I2,$A$2:$A$100))

    This is an array function so Ctrl+Shift+Enter

    E3 =MIN(IF($B$2:$B$100=$I3,$A$2:$A$100))
    Last edited by rwgrietveld; 01-08-2010 at 07:22 PM.
    Looking for great solutions but hate waiting?
    Seach this Forum through Google

    www.Google.com
    (e.g. +multiple +IF site:excelforum.com/excel-general/ )

    www.Google.com
    (e.g. +fill +combobox site:excelforum.com/excel-programming/ )

    Ave,
    Ricardo

  3. #3
    Registered User
    Join Date
    04-06-2009
    Location
    Austin, TX
    MS-Off Ver
    Excel 2007
    Posts
    34

    Re: Index and Match Dates and Values

    Thank you very much. Any suggestions on reading material to help me think simpler? It seems that I always want to write these complicated functions.

    Thanks!!!

+ 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