et a zs ux

---

---

What is this?

jNizM wrote:Counter-Strike 1.6 rewritten client.dll. Without VGUI, ParticleMan. And ecology friendy. for Android

Imagine eSport on Phones

Hab mittlerweile die Lösung gefunden! Danke trotzdem :) Num := [], RowToDelete := [] xl := ComObjActive("Excel.Application") for cell in xl.ActiveSheet.UsedRange.Columns(1).cells { if !Num[cell.text] Num[cell.text] := cell.offset(0,1) else { Num[cell.text].value := cell.offset(0,1).value RowToDelete...

The problem is "Click" only is the Click itself, if you wanna drag something you have to use "Click down"

Num := [], RowToDelete := [] xl := ComObjActive("Excel.Application") for cell in xl.ActiveSheet.UsedRange.Columns(1).cells { if !Num[cell.text] Num[cell.text] := cell.offset(0,1) else { Num[cell.text].value := cell.offset(0,1).value RowToDelete.push(cell.row) } } for i, row in RowToDelete xl.rows(r...

Danke für die Antwort! Grundsätzlich ist beides in Ordnung, ersteres wäre mir glaub ich aber lieber. "Für mich gibt es z.B. neben einer Spalte nur Spalten, keine Zeilen." Whoops, genau das meinte ich. Wegen dem Beispiel: - - - - - | -A- | -B- Zeile 1 | 500 | Hallo Zeile 2 | 316 | Ort Zeile 3 | 262 |...

If there are multiple duplicates, do you want the final duplicate to be repeated in every matching row? There are max. 2 duplicates Do you want the first matching row to be deleted? (Yes) What do you want to do with the duplicate data? -> In the end i have a number in the first column and informatio...

So basically what you want is this
If you want to have a short break in it use Sleep, 50

Hallo, folgendes Problem: Ich möchte aus einer Excel-Liste herausfinden ob es in einer Spalte ein Duplikate gibt, falls es so sein sollte, möchte ich aus der Zeile daneben (!) des zweiten Duplikates, die Informationen kopieren und in die Zeile neben des ersten Duplikat einfügen. Falls es einfacher g...

Hello, i'm using AHK for the first time in EXCEL and i need a lil help! :) I wanna check if there are duplicates in a column, if it says yes than it should copy the information of the next column of the second duplicate and paste it into the first one. If this isn't possible i could seperate both EX...