Search found 10 matches

by 1A_OS
20 Apr 2016, 07:16
Forum: Offtopic
Topic: Test your Forum Posts
Replies: 386
Views: 100524

Re: Test your Forum Posts

et a zs ux


Textbbbb

What is this?
by 1A_OS
20 Apr 2016, 06:34
Forum: Offtopic
Topic: « What's on your mind? »
Replies: 4217
Views: 708563

Re: « What's on your mind? »

by 1A_OS
20 Apr 2016, 06:15
Forum: Ich brauche Hilfe
Topic: EXCEL - Duplikate kopieren und einfügen
Replies: 3
Views: 730

Re: EXCEL - Duplikate kopieren und einfügen

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...
by 1A_OS
20 Apr 2016, 04:30
Forum: Ask For Help
Topic: How to prevent hotkeys from being eaten Topic is solved
Replies: 3
Views: 587

Re: How to prevent hotkeys from being eaten Topic is solved

The problem is "Click" only is the Click itself, if you wanna drag something you have to use "Click down"
by 1A_OS
20 Apr 2016, 02:00
Forum: Ask For Help
Topic: EXCEL - Copy and Paste Duplicates
Replies: 5
Views: 1187

Re: EXCEL - Copy and Paste Duplicates

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...
by 1A_OS
19 Apr 2016, 09:03
Forum: Ich brauche Hilfe
Topic: EXCEL - Duplikate kopieren und einfügen
Replies: 3
Views: 730

Re: EXCEL - Duplikate kopieren und einfügen

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 |...
by 1A_OS
19 Apr 2016, 07:21
Forum: Ask For Help
Topic: EXCEL - Copy and Paste Duplicates
Replies: 5
Views: 1187

Re: EXCEL - Copy and Paste Duplicates

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...
by 1A_OS
19 Apr 2016, 03:28
Forum: Ask For Help
Topic: Help me please im new
Replies: 1
Views: 399

Re: Help me please im new

So basically what you want is this

Code: Select all

~Shift:: 
	SendInput, QQQ
return

WheelDown::
	SendInput, EEE
return
If you want to have a short break in it use Sleep, 50
by 1A_OS
19 Apr 2016, 02:39
Forum: Ich brauche Hilfe
Topic: EXCEL - Duplikate kopieren und einfügen
Replies: 3
Views: 730

EXCEL - Duplikate kopieren und einfügen

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...
by 1A_OS
19 Apr 2016, 02:31
Forum: Ask For Help
Topic: EXCEL - Copy and Paste Duplicates
Replies: 5
Views: 1187

EXCEL - Copy and Paste Duplicates

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...

Go to advanced search