CodeDocu.com

 
 
 
Remove duplicate rows , remove duplicates
 
To remove duplicate rows or unnecessary lines:
 
You select a range or table in Excel
Then Excel->Menu->Data->Remove duplicates
Then you can select the columns after which you want to dissolve or collapse the list
Excel Instructions: Remove Duplicate Rows, Remove Duplicates
 
 
 
Remove Excel list by duplicates
Excel Instructions: Remove Duplicate Rows, Remove Duplicates
 
 
Ungefilterte List:
This list is a large list with many duplicates, unnecessary lines
 

[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

 
 
Remove after duplicates
The list is much clearer
 

[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

 
 
 
 
 
 

Software Entwicklung Stuttgart NĂ¼rtingen
Suche Projekte C#, WPF, Windows App,ASP.Net, vb.Net, WinForms, SQL Server, Access, Excel