Hello all


I am stuck, I need some support please.

I would like to build in some automatism for my process. created this document. I have some difficulties with the automation of the consecutive numbering, as a formula as well as text.

For example, if I select the fields "H4-H11" and then drag them down the logical sequential numbering does not match the numbering in the with this in the document. From an Excel logic perspective I have to agree with the numbering of the fields, but I need them need it numbered accordingly as I know it from 1-49.


---

I have an identical problem in rows "A8-A10". I have created the first three lines "manually", hoping that the numbering numbering from the pattern with the drag down automatically.

=TEXTKETTE("int"&B2&"01") <<-- Created manually
=TEXTKETTE("int"&B2&"02") <<-- Created manually
=TEXTKETTE("int "&B2& "03") <<-- Manually created, selected and dragged down 3 fields.
=TEXTKETTE("int"&B5&"01") <<-- Why is line B5 and the numbering starts again at 1?
=TEXTKETTE("int"&B5& "02")
=TEXTKETTE("int "&B5& "03")

Thanks
M

Attached Files

Counting.xlsx (15.4 KB, 5 views)