Numbering

[Agalloch]

Hello. At the first i am sorry for my english. So i hope you will understand what i want.

At the first, look at the picture included in attachment.

My goal /question is, how can i get "automatic line ordering" based from number 1019001 on B column. When i press enter, it ads one more number so it goes 1019002, 1019003 ..... but only on B column

Starting B3 - 10190001

Thanks for the help.

[Jan_J]

Mark both columns as a block; then sort it with respect to B.
When you do not use block, the ordering may affect only current column; it depends on personal Calc settings.

[Agalloch]

Oh yea, thats my english, i already said i am not sure you will undertand. Actually I WAS WRONG.
What i wanted to ask about, is how to get something like, when i press enter so i move to B24, it adds automaticaly next number, like 10190022. B25 > 10190023 etc. I am very sorry for previous question.

[RusselB]

Do the entries in column B always start with 101900 with the incrementing number coming after that or did you intend to have the sequence go from 1019009 to 1019010?

[Agalloch]

Yes. Till the end of this year. 10190xxx (001, 002, 003, 004---)

Next year ill use another document where it starts with 1020xxx (001, 002, 003...)

[Zizi64]

Code: Select all

1019009
10190010

The difference is not +1 in this case. Your example based on some textual labelling "values", but not based on a real numeric incrementation.

[Agalloch]

Is it possible to make it like +1 ?
10190001
....
10190010
....
10190100
...
etc?

[Zizi64]

If the first data is located in the cell B1, then copy this formula into B2:

Code: Select all

=IF(ISBLANK(C2;"";B1+1)

Then copy the formula down to the last cell what will be used in the future.

The cells in the column B will be "filled automatically", when you enter the next date value in the column C.

[Lupp]

Taking the request literally (and in accordance with the image showing the next number in a row where nothing was entered in column C) I would assume it cannot be done without relying on user code.

[Agalloch]

It returns error for me.

[Zizi64]

It returns error for me.

Please upload your ODF type sample file here.

[Lupp]

If reporting an error, please always give the complete error message, or (in case of a formula error like here) the error number.
In this case it surely was "Err:508" because Zizi64 had omitted a closing parenthese. His formula corrected would read

Code: Select all

=IF(ISBLANK(C2);"";B1+1)

508
Error: Pair missing
Missing bracket, for example, closing brackets, but no opening brackets

[Lupp]

If reporting an error, please always give the complete error message, or (in case of a formula error like here) the error number.
In this case it surely was "Err:508" because Zizi64 had omitted a closing parenthese. His formula corrected would read

Code: Select all

=IF(ISBLANK(C2);"";B1+1)

508
Error: Pair missing
Missing bracket, for example, closing brackets, but no opening brackets

(It seems a strange idea to me to denote the year 2019 by "1019".)

[Zizi64]

"Err:508" because Zizi64 had omitted a closing parenthese. His formula corrected would read

Code: Select all

 =IF(ISBLANK(C2);"";B1+1)

Oh yes. Sorry.