+ Reply to Thread
Results 1 to 7 of 7

Count 0001

  1. #1
    Registered User
    Join Date
    04-15-2014
    Location
    Tirana, Albania
    MS-Off Ver
    Excel 2007
    Posts
    12

    Question Count 0001

    hi I have this table,

    EL3 EL4 EL5 EL6
    A31 1-Jan 1 AL1S0001
    A06 12-Feb 2 AL2C0002
    A35 14-May 30 AL5C0003
    ---------------------------------------
    A34 12-Jul 135 AL7C0015
    A31 10-Aug 50 AL8S0122

    For the EL6 Column, can exist a formula that calculates as show in the table above.

    the EL6 is consist in "AL,MONTH (from EL4), "S" if A31, C if anything else, and 0000 (4 characters always) that counts 0000,0001,0002....0112 as in the table above.

    i figure out this formula "=CONCATENATE("AL",MONTH(EL4),IF(EL3="A31","S","C")), but cant find a way to count in this format (0000,0001,0002....0112)

    can some one please help

  2. #2
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Count 0001

    Assuming I understood your question correctly, would something like the attached worksheet help?
    Attached Files Attached Files
    Spread the love, add to the Rep

    "None of us are as smart as all of us."

  3. #3
    Registered User
    Join Date
    04-15-2014
    Location
    Tirana, Albania
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Count 0001

    This formula almost solved my problem,

    only that you need me to count for "S" and "C" to be independent and to start over again for every month (EL4) .

    AL1S0001
    AL1C0001
    AL1S0002
    AL1C0002
    ----------
    AL2S001
    AL2C001
    AL2C002
    AL2S002

    how ever thanks a lot it helped understand some new formulas, thanks

  4. #4
    Registered User
    Join Date
    04-15-2014
    Location
    Tirana, Albania
    MS-Off Ver
    Excel 2007
    Posts
    12

    Talking Re: Count 0001

    This formula almost solved my problem,

    only that you need me to count for "S" and "C" to be independent and to start over again for every month (EL4) .

    AL1S0001
    AL1C0001
    AL1S0002
    AL1C0002
    ----------
    AL2S001
    AL2C001
    AL2C002
    AL2S002

    how ever thanks a lot it helped understand some new formulas, thanks

  5. #5
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Count 0001

    Ahh I understand now. Try this formula in the previous workbook I attached and paste into cell D2 and drag down:

    Please Login or Register  to view this content.
    Does this work?
    Last edited by mcmahobt; 12-19-2014 at 10:19 AM.

  6. #6
    Registered User
    Join Date
    04-15-2014
    Location
    Tirana, Albania
    MS-Off Ver
    Excel 2007
    Posts
    12

    Re: Count 0001

    works brilliantly ,

    many thanks

  7. #7
    Forum Expert
    Join Date
    09-11-2014
    Location
    Washington, DC
    MS-Off Ver
    2016
    Posts
    1,905

    Re: Count 0001

    Happy to help! If this solves your problem, please take a moment to mark this thread as [SOLVED] using thread tools.

+ 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] conversion of 1 to 0001
    By vjharry in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 05-13-2013, 10:48 AM
  2. [SOLVED] Number list with anteceding zeros (0001-3000)
    By NathanC in forum Excel General
    Replies: 3
    Last Post: 09-10-2012, 02:52 PM
  3. Range.columns.count property returns wrong count after union operation
    By gopinan in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-13-2008, 04:48 AM
  4. [SOLVED] Number format need to display 0001 etc
    By Carys in forum Excel General
    Replies: 4
    Last Post: 07-27-2006, 02:25 PM
  5. Replies: 18
    Last Post: 09-06-2005, 06:05 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