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