Readdy Write  
0,00 €
Your View Money
Views: Count
Self 20% 0
Your Content 60% 0

Users by Links 0
u1*(Content+Views) 10% 0
Follow-Follower 0
s2*(Income) 5% 0

Count
Followers 0
Login Register as User

Excel Anleitung: Doppelte Zeilen entfernen , Duplikaten entfernen

22.04.2020 (👁12714)


Doppelte Zeilen entfernen , Duplikate entfernen

So entfernt man doppelte Zeilen oder unnötige Zeilen:

Man markiert einen Bereich oder eine Tabelle in Excel

Dann Excel->Menü->Daten->Duplikate entfernen

Anschließend kann man die Spalten markieren, nach welchen man die Liste auflösen oder reduzieren möchte

Excel Liste nach Duplikate entfernen

Ungefilterte Liste:

Diese Liste ist eine große Liste mit vielen Duplikaten, unnötigen Zeilen

[04/21/20 16:53:48]****************** LOG FILE STARTED *******************

04/21/20 16:53:51

SMTP-IN

828

77.40.3.212

220 mail.rue25.de ESMTP MailEnable Service, Version: 10.29-- ready at 04/21/20 16:53:51

89

0

04/21/20 16:53:51

SMTP-IN

828

77.40.3.212

EHLO

EHLO localhost.localdomain

250-rue25.de [77.40.3.212], this server offers 4 extensions

211

28

04/21/20 16:53:51

SMTP-IN

828

77.40.3.212

UNKN

STARTTLS

503 Bad sequence of commands

30

10

04/21/20 16:53:52

SMTP-IN

856

77.40.3.212

220 mail.rue25.de ESMTP MailEnable Service, Version: 10.29-- ready at 04/21/20 16:53:52

89

0

04/21/20 16:53:52

SMTP-IN

856

77.40.3.212

EHLO

EHLO localhost.localdomain

250-rue25.de [77.40.3.212], this server offers 4 extensions

211

28

04/21/20 16:53:52

SMTP-IN

856

77.40.3.212

UNKN

STARTTLS

503 Bad sequence of commands

30

10

04/21/20 16:54:15

SMTP-IN

860

45.142.195.3

220 mail.rue25.de ESMTP MailEnable Service, Version: 10.29-- ready at 04/21/20 16:54:15

89

0

04/21/20 16:54:17

SMTP-IN

860

45.142.195.3

EHLO

EHLO User

250-rue25.de [45.142.195.3], this server offers 4 extensions

212

11

04/21/20 16:54:19

SMTP-IN

860

45.142.195.3

RSET

RSET

250 Requested mail action okay, completed

43

6

04/21/20 16:54:21

SMTP-IN

876

40.107.14.53

220 mail.rue25.de ESMTP MailEnable Service, Version: 10.29-- ready at 04/21/20 16:54:21

89

0

04/21/20 16:54:21

SMTP-IN

876

40.107.14.53

EHLO

EHLO EUR01-VE1-obe.outbound.protection.outlook.com

250-rue25.de [40.107.14.53], this server offers 4 extensions

212

52

04/21/20 16:54:21

SMTP-IN

876

40.107.14.53

MAIL

MAIL FROM:<Raimund.Popp@comline-se.de> SIZE=29751

250 Requested mail action okay, completed

43

51

04/21/20 16:54:21

SMTP-IN

860

45.142.195.3

AUTH

AUTH LOGIN

334 VXNlcm5hbWU6

18

12

04/21/20 16:54:22

SMTP-IN

876

40.107.14.53

RCPT

RCPT TO:<raimund@rue25.de>

250 Requested mail action okay, completed

43

28

04/21/20 16:54:22

SMTP-IN

876

40.107.14.53

DATA

DATA

354 Start mail input; end with <CRLF>.<CRLF>

46

6

04/21/20 16:54:24

SMTP-IN

860

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

18

rec@rue25.de

04/21/20 16:54:26

SMTP-IN

860

45.142.195.3

AUTH

MTIzNDU2Nzg5MA==

535 Invalid Username or Password

34

18

rec@rue25.de

04/21/20 16:54:28

SMTP-IN

860

45.142.195.3

QUIT

QUIT

221 Service closing transmission channel

42

6

rec@rue25.de

04/21/20 16:54:43

SMTP-IN

1012

113.10.169.166

220 mail.rue25.de ESMTP MailEnable Service, Version: 10.29-- ready at 04/21/20 16:54:43

89

0

04/21/20 16:54:43

SMTP-IN

1012

113.10.169.166

EHLO

EHLO ADMIN

250-rue25.de [113.10.169.166], this server offers 4 extensions

214

12

04/21/20 16:54:43

SMTP-IN

1012

113.10.169.166

AUTH

AUTH LOGIN

334 VXNlcm5hbWU6

18

12

04/21/20 16:54:44

SMTP-IN

1012

113.10.169.166

AUTH

{blank}

334 UGFzc3dvcmQ6

18

30

access@codedocu.com

04/21/20 16:54:44

SMTP-IN

1012

113.10.169.166

AUTH

Y29kZWRvY3U=

535 Invalid Username or Password

34

14

access@codedocu.com

04/21/20 16:54:44

SMTP-IN

1012

113.10.169.166

QUIT

QUIT

221 Service closing transmission channel

42

6

access@codedocu.com

04/21/20 16:54:52

SMTP-IN

856

45.142.195.3

220 mail.rue25.de ESMTP MailEnable Service, Version: 10.29-- ready at 04/21/20 16:54:52

89

0

04/21/20 16:54:54

SMTP-IN

856

45.142.195.3

EHLO

EHLO User

250-rue25.de [45.142.195.3], this server offers 4 extensions

212

11

04/21/20 16:54:56

SMTP-IN

856

45.142.195.3

RSET

RSET

250 Requested mail action okay, completed

43

6

04/21/20 16:54:58

SMTP-IN

856

45.142.195.3

AUTH

AUTH LOGIN

334 VXNlcm5hbWU6

18

12

04/21/20 16:55:00

SMTP-IN

856

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

22

marti@rue25.de

04/21/20 16:55:03

SMTP-IN

856

45.142.195.3

AUTH

MTIzNDU2Nzg5MA==

535 Invalid Username or Password

34

18

marti@rue25.de

04/21/20 16:55:05

SMTP-IN

856

45.142.195.3

QUIT

QUIT

221 Service closing transmission channel

42

6

marti@rue25.de

Nach Duplikate entfernen

Die Liste ist wesentlich übersichtlicher

[04/21/20 16:53:48]****************** LOG FILE STARTED *******************

04/21/20 16:54:24

SMTP-IN

860

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

18

rec@rue25.de

04/21/20 16:54:44

SMTP-IN

1012

113.10.169.166

AUTH

{blank}

334 UGFzc3dvcmQ6

18

30

access@codedocu.com

04/21/20 16:55:00

SMTP-IN

856

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

22

marti@rue25.de

04/21/20 16:55:37

SMTP-IN

932

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

22

enzo@rue25.de

04/21/20 16:56:14

SMTP-IN

880

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

22

greg1@rue25.de

04/21/20 16:56:51

SMTP-IN

912

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

18

wws@rue25.de

04/21/20 16:57:28

SMTP-IN

968

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

18

you@rue25.de

04/21/20 16:58:05

SMTP-IN

980

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

18

san@rue25.de

04/21/20 16:58:41

SMTP-IN

1000

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

26

gardien@rue25.de

04/21/20 16:59:18

SMTP-IN

912

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

22

umesh@rue25.de

04/21/20 16:59:52

SMTP-IN

1008

185.50.149.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

46

xuuut@microsoft-programmierer.de

04/21/20 16:59:55

SMTP-IN

876

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

22

michel@rue25.de

04/21/20 16:59:58

SMTP-IN

868

185.50.149.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

10

xuuut

04/21/20 17:00:32

SMTP-IN

916

45.142.195.3

AUTH

{blank}

334 UGFzc3dvcmQ6

18

22

voyage@rue25.de