Excel Anleitung: Doppelte Zeilen entfernen , Duplikaten
entfernen
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
|