# Count 0001

1. ## 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)

2. ## Re: Count 0001

Assuming I understood your question correctly, would something like the attached worksheet help?

3. ## 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. ## 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. ## 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?

6. ## Re: Count 0001

works brilliantly ,

many thanks

7. ## Re: Count 0001

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

##### Users Browsing this Thread

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

#### 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