#1
|
|||
|
|||
fighting with counting
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 |
#2
|
|||
|
|||
Sorry i poste the same message two times here!
i dont found the possibiliites to delete the other one, Thanks |
#3
|
||||
|
||||
Tyr in A8:
="int "&$B$2& TEXT(ROW(A1),"00") and copy down. |
#4
|
|||
|
|||
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 |
#5
|
||||
|
||||
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 Last edited by p45cal; 05-13-2023 at 09:49 AM. |
#6
|
||||
|
||||
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 |
#7
|
|||
|
|||
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 |
#8
|
||||
|
||||
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. |
#9
|
|||
|
|||
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!! |
#10
|
||||
|
||||
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. |
#11
|
|||
|
|||
yes i have Office 365, and yes its running. Thanks meny time!
|
#12
|
||||
|
||||
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 |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Counting | dayjef | Excel | 4 | 02-23-2016 03:00 PM |
Counting Graphics | mohsen.amiri | Word | 5 | 06-22-2015 08:52 PM |
Counting unique visitors by ward, counting monthly visits by status, editing existing workbook | JaxV | Excel | 9 | 11-14-2014 12:25 AM |
Counting Formula | Karen615 | Excel | 6 | 06-20-2011 07:19 PM |
Counting Colors | g48dd | Excel | 2 | 03-13-2011 09:28 PM |