Results 1 to 23 of 23

Find dates with matching month and year on a row -> return value 2 columns to the right

Threaded View

  1. #1
    Registered User
    Join Date
    11-15-2012
    Location
    Romppa, Finland
    MS-Off Ver
    Excel 2010
    Posts
    25

    Question Find dates with matching month and year on a row -> return value 2 columns to the right

    Okay, the title probably sounds really confusing, but what I am trying to accomplish, is a formula, that would go through values (dates) on a row. When a date with same year and month is found, it would return the value two columns right. Note, that there might be several matching cells with same month/year, so it shouldn't stop on the first match found.

    So far, I've tried something like this:

    INDEX(A2:J2;1;MATCH(DATE(YEAR(A1);MONTH(A1);1)+2;A2:J2;0))

    Note, that I am using Finnish excel, so ';' might have to be replaced with ','..


    \1

    Please help!
    Attached Images Attached Images
    Last edited by Cumbo; 11-20-2012 at 02:45 AM.

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