SOLVED

Excel Auto-fill sekundäre Daten

%3CLINGO-SUB%20id%3D%22lingo-sub-3235968%22%20slang%3D%22de-DE%22%3EExcel%20Auto-fill%20Secondary%20Data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3235968%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%3C%2FP%3E%3CP%3EI%20want%20to%20fill%20cells%20automatically%2C%20but%20they%20do%20not%20change%20in%20the%20last%20number%2C%20but%20change%20in%20the%20middle%20of%20the%20number.%3C%2FP%3E%3CP%3EHere%20is%20an%20example%3A%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Klesche94_0-1646153436905.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352110i72E47FEA6F6D994D%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Klesche94_0-1646153436905.png%22%20alt%3D%22Klesche94_0-1646153436905.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3EMy%20list%20only%20repeats%20the%20entries%20instead%20of%20continuing%20them%20sensibly.%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Klesche94_1-1646153492975.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F352111i2A06C3ED925CEBB0%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22Klesche94_1-1646153492975.png%22%20alt%3D%22Klesche94_1-1646153492975.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20it%20possible%20to%20automatically%20fill%20the%20second%20number%20after%20the%20-%20ascending%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-3235968%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3237185%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Auto-fill%20sekund%C3%A4re%20Daten%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3237185%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1321078%22%20target%3D%22_blank%22%3E%40Klesche94%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CPRE%20class%3D%22lia-code-sample%20language-applescript%22%3E%3CCODE%3E%3DREPLACE(B16%2C6%2CSEARCH(%22-%22%2CB16%2CSEARCH(%22-%22%2CB16)%2B1)-1-SEARCH(%22-%22%2CB16)-2%2CCOLUMN(C14))%3C%2FCODE%3E%3C%2FPRE%3E%3CP%3EIs%20this%20what%20you%20are%20looking%20for%3F%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-3237553%22%20slang%3D%22de-DE%22%3ERe%3A%20Excel%20Auto-fill%20secondary%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-3237553%22%20slang%3D%22de-DE%22%3EThank%20you%20very%20much!%3CBR%20%2F%3ENow%20I%20just%20have%20to%20understand%20the%20other%20two%20formulas%20and%20then%20I%20can%20apply%20it%20that%20way.%20%3A'D%3C%2FLINGO-BODY%3E
New Contributor

Hallo,

ich möchte Zellen automatisch füllen, welche sich aber nicht in der letzten Zahl ändern, sondern mitten in der Zahl ändern.

Hier ein Beispiel:

Klesche94_0-1646153436905.png

Meine Liste wiederholt nur die Eingaben, anstatt diese sinnig weiterzuführen.

Klesche94_1-1646153492975.png

 

Ist es möglich die zweite Zahl nach dem - aufsteigend automatisch zu füllen?

 

2 Replies
best response confirmed by Klesche94 (New Contributor)
Solution

@Klesche94 

=REPLACE(B16,6,SEARCH("-",B16,SEARCH("-",B16)+1)-1-SEARCH("-",B16)-2,COLUMN(C14))

Is this what you are looking for? 

Vielen lieben Dank!
Jetzt muss ich nur noch die anderen beiden Formeln verstehen und dann kann ich das so anwenden. :'D