+ Reply to Thread
Results 1 to 4 of 4

Identify start month and repeat the same value in the next 12 cells

  1. #1
    Registered User
    Join Date
    02-28-2010
    Location
    Bangalore, INDIA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Identify start month and repeat the same value in the next 12 cells

    Dear Friends,

    I am working on a formula by it is repeatedly failing. Please help.

    Based on input 1 which is the month name, I am looking for a formula to identify the position across columns as the starting cell and then the value in input 2 needs to be repeated 12 times from there.

    Example:
    Input 1 is Apr-14
    Input 2 is 51.8

    I have columns with month names starting Apr-13 to Mar-15

    Since the input 1 is Apr-14, the formula should identify the appropriate column named as Apr-14 and from there it should copy the value (input 2 ) 51.8 for the next 12 cells which is until Mar-15. I have attaches the examples for your quick reference.
    Please feel free to modify the date/month formats.

    With Regards,
    Venu
    Attached Files Attached Files

  2. #2
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,970

    Re: Identify start month and repeat the same value in the next 12 cells

    Put this formula in C7:

    =IF(C$6<$A7,"",IF(C$6>$A7+364,"",$B7))

    then copy across and down as required.

    Hope this helps.

    Pete

  3. #3
    Registered User
    Join Date
    02-28-2010
    Location
    Bangalore, INDIA
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: Identify start month and repeat the same value in the next 12 cells

    Many thanks. Working great.

  4. #4
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,970

    Re: Identify start month and repeat the same value in the next 12 cells

    Glad to be able to help - thanks for the rep.

    Pete

+ 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. Identify Repeat Purchases Within a Specific Time
    By zegatron in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-23-2014, 07:41 AM
  2. Replies: 6
    Last Post: 03-03-2013, 01:41 AM
  3. [SOLVED] VBA to identify the current month and previous month based on system date
    By ravikumar00008 in forum Excel General
    Replies: 10
    Last Post: 07-26-2012, 10:04 AM
  4. [SOLVED] COUNTIF to identify non-repeat values
    By suniljayanna in forum Excel General
    Replies: 3
    Last Post: 07-14-2012, 02:20 PM
  5. Identify a range, pull first instance of a symbol, repeat
    By Jbm444 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 07-09-2010, 07:01 PM

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