+ Reply to Thread
Results 1 to 3 of 3

Full fill amount with year ages criteria

  1. #1
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Full fill amount with year ages criteria

    hi all....

    i am looking for some formula to full fill year ages as criteria (desired result)

    with condition,
    1. At start in cell A3 down with 4 left digits number as "year" and 2 mid digits as "month"
    e.g.; 1996.06.000007 --- 1996 (as year) and 06 (as June month )
    2010.07.001235 ---- 2010 (as year) and 07 (as July month )
    2. "yellow area" (age bills) is the desired result, start from column D, drag right down

    please, see my workbook upload....

    thanks in advance for the help..

    john mustofa
    Attached Files Attached Files

  2. #2
    Forum Expert Tinbendr's Avatar
    Join Date
    06-26-2012
    Location
    USA
    MS-Off Ver
    Office 2010
    Posts
    2,125

    Re: Full fill amount with year ages criteria

    This is all I could come up with. see attachment.
    Attached Files Attached Files
    David
    (*) Reputation points appreciated.

  3. #3
    Forum Contributor
    Join Date
    01-22-2013
    Location
    Pekanbaru, Indonesia
    MS-Off Ver
    Excel 2013 & Google Sheet
    Posts
    1,146

    Re: Full fill amount with year ages criteria

    Tinbendr, many thanks, it'was very helpfull

+ 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. Replies: 3
    Last Post: 01-02-2014, 01:45 PM
  2. Duplicate date 3 times for a full year in one column
    By puchimo in forum Excel General
    Replies: 5
    Last Post: 11-14-2012, 08:46 PM
  3. [SOLVED]Change Macro to enter full amount
    By auntsally in forum Excel General
    Replies: 8
    Last Post: 03-20-2010, 07:14 AM
  4. Charting a full year without zeros
    By Brisbane Rob in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 05-28-2008, 03:29 PM
  5. Criteria Between two ages problem
    By kev030981 in forum Excel Formulas & Functions
    Replies: 11
    Last Post: 11-07-2006, 01:08 AM

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