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, 3 views)

Sorry i poste the same message two times here!
i dont found the possibiliites to delete the other one, Thanks

Tyr in A8:
="int "&$B$2& TEXT(ROW(A1),"00")
and copy down.

First let thanks for your quick answer


i try this, but it will come back any Error, for your information i use Office365


please see the picture

Attached Images

formel.jpg (194.9 KB, 15 views)

in your locale it might be:
="int "& $B$2 & TEXT(ZEILE(A1),"00")
To copy down successfully, it must be $B$2
and I think you should start with A1, not A2

Or perhaps ...;"00)

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Wau yes this it's music, Splendend !!
sorry but that's exactly what I was hoping for, Thans meny time!!


--


Please, please I don't want to be rude, but can we also take this
in the fields H4-h11 and then pull down the rest ?


thanks meny thanks

Does the single-cell formula at cell I3 work?
Probably not, if you're using Excel 2016.
But are the results correct?

I'll look at this further later…


update:
In sheet Aufbau (2) of the attached (updated file) there's a Power Query (built in to Excel 2016) solution; change the source data (blue table on the left) then update the result table in cell I2 by right-clicking that result table and choosing Refresh.

Attached Files

msofficeforums50861Counting.xlsx (32.6 KB, 4 views)

yes, you are a genius!, Appair correct


it will appair on both "Aufbau" and "Aufbau(2)" as correct


Also if you cange the field "Obere Dosenreihe" or "Untere Dosenreihe" will change the settings to the hole sheet. that seems the right solution!


i need to understod, how this will work!!! Thanks meny time for your quick and right Answer, i was thinking this are a unsolvable task!!





AMAZING!!!


really best thanks!!

So the formula in cell I3 on the sheet Aufbau works?! You have Office 365?
This formula will update by itself.


The other sheet is a Power Query transformation, needa a proper Excel table as the source data, and needs to be refreshed manually (like a Pivot table) if the source table changes. You would use this if you don't have Office 365.

yes i have Office 365, and yes its running. Thanks meny time!

Then perhaps change your profile accordingly?

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post