+ Reply to Thread
Results 1 to 5 of 5

Return First and Last Month with Data in By-Month Table

  1. #1
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    163

    Return First and Last Month with Data in By-Month Table

    Hi,

    I'm hoping someone could help me out with a formula that returns the first and last month that data is entered into in a columned by-month table.

    I have a sheet w/ month's across the top (headers) and projects down the first column. If data is input in one row with values from February to October, I'm hoping to have a formula that will return "Feb-Oct", this should also work if there are breaks within the phasing (for instance if there were month's with that range with no data).

    Please tell me this is possible, it would save a *ton* of time (without a formula, I'll have to manually go row-by-row typing out what the timeline of each project is...and I'm hoping to avoid that).

    Thank you!

  2. #2
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Return First and Last Month with Data in By-Month Table

    Can you post a SMALL sample file and show us what result you expect?

    A SMALL file will have about 20 rows worth of data.
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Return First and Last Month with Data in By-Month Table

    THis will give you the last date. Im still working on the start date...
    A
    B
    C
    D
    E
    F
    G
    H
    1
    Jan Feb Mar Apr May Jun Jul
    2
    aa
    10
    2
    3
    4
    3
    bb
    11
    22
    33
    44
    55
    4
    cc
    111
    222
    333
    5
    6
    7
    aa May
    8
    bb Jul
    9
    cc Jun

    B7=INDEX($B$1:$H$1,MATCH(0,B2:H2,-1))
    copied down
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  4. #4
    Valued Forum Contributor
    Join Date
    05-20-2013
    Location
    Ohio, USA
    MS-Off Ver
    Excel 2013
    Posts
    941

    Re: Return First and Last Month with Data in By-Month Table

    Assuming same arrangement as Ford, but formula in N2 and copied down...

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    11-10-2011
    Location
    New York, NY
    MS-Off Ver
    MS Office: Excel 365
    Posts
    163

    Re: Return First and Last Month with Data in By-Month Table

    omg! thank you guys so much!!!!!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Formula to return End OF Month date with non-calendar month lengths.
    By Snoddas in forum Excel Formulas & Functions
    Replies: 18
    Last Post: 05-09-2014, 08:45 AM
  2. Return value of the last week of the month based on the year and month
    By stevekho2 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 09-14-2013, 11:04 AM
  3. Return month even if first sunday is in previous month?
    By jordiejones in forum Excel General
    Replies: 2
    Last Post: 03-22-2011, 07:54 PM
  4. Type in Month-Year and return 3rd wednesday of month
    By learntheweek in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-09-2010, 11:29 AM
  5. Replies: 3
    Last Post: 09-25-2007, 10:26 AM

Tags for this Thread

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