Continuing a certain sequence in Excel

[rooly]

Hi.


Is there a way to continue the following string of numbers in this order , that will continue automatically in Excel? The character - must appear ..

01-01-01
01-01-02
01-01-03
01-01-04
01-01-05
01-02-01
01-02-02
01-02-03
01-02-04
01-02-05

[Pecoflyer]

Hi
enter 01-01-01 in A1 then in A2

="01-"&TEXT(CEILING(ROW()/5,1),"00")&"-"&TEXT(IF(RIGHT(A1,2)*1=5,1,RIGHT(A1,2)+1),"00")

and pull down as needed There should be something more elegant, though

Edit : supposing you start on row 1

[Pecoflyer]

Post deleted

[ArviLaanemets]

In attachement is an example.

[rooly]

Thanks . The table you uploaded stops at 01-04-05 . How do I continue on to 01-05-01 Etc..


cross posts:
https://www.excelforum.com/excel-gen...ml#post4875152

[Pecoflyer]

Originally Posted by ArviLaanemets

In attachement is an example.

Please follow mods request and do not answer posts before the OP has complied. Thank you

[Pecoflyer]

@ rooly
Perhaps try post #2

[ArviLaanemets]

Originally Posted by Pecoflyer

Please follow mods request and do not answer posts before the OP has complied. Thank you

When I started to write the answer, there was only opening post!

[ArviLaanemets]

Originally Posted by rooly

The table you uploaded stops at 01-04-05 . How do I continue on to 01-05-01 Etc..

Limit1 or whatever it was (I don't have Excel currently so I'm not sure how I named them exactly) (at top of page are 3 limits, btw you can have them on separate sheet, or you can simply define them as names when those limits are fixed) determines the max number allowed in 1st 2 characters of code, and as result the range the formulas calculate the code for. So set the Limit1 to 99, and you get the max of the table with current Limit2 and Limit3.

Wait! At 01-04-05! I have to check the formula, but it takes some time. I have to connect to another computer.

It stops at 03-04-05 - what is right as Limit1=3, Limit2=4 and Limit3=5.

[Pecoflyer]

Originally Posted by ArviLaanemets

When I started to write the answer, there was only opening post!

Between my post about cross posting and your post, two hours went by.
I would suggest refreshing your browser page regularly (F5) to see what's going on. Answers can come very fast on a forum ( or sometimes very slowly)

[ArviLaanemets]

Originally Posted by Pecoflyer

...

I was distracted - my wife had some tasks for me meanwhile

And I learned on hard way not to refresh anything when writing the post (or at least when editing). When I edit the post, then sometimes I cant save the edited post (simply nothing happens). Now, when this happens, I copy the whole post and then refresh the sheet. As result the editing window is closed! After I lost some work this way, now I open the post anew for editing, and paste it over with copied text. I haven't tried yet, how new post will behave, but logically not very differently!

[Pecoflyer]

There is a saying in French ( and probably an equivalent in English) :"Ce que femme veut, Dieu le veut".
So if the missis had tasks for you you had a high priority mission !
You're right about refreshing and editing, I hadn't thought about that one.
I usually " soft delete" answers as long as no links to cross posts are provided, and undelete when they are.
Let's see if the OP follows up on this one.
Cheers