| |

VerySource

 Forgot password?
 Register
Search
View: 27|Reply: 2

Excuse me: how to merge the same items in EXCEL?

[Copy link]

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 Invalid IP Address

Post time: 2020-3-17 22:00:01
| Show all posts |Read mode
As the following table:
Adress Comment
% IX12.5 I102
% IX12.5 I102
% IX12.5 I102
% IX12.5 I102
% IX12.5 I102
% IX12.5 I102
% IX12.6 I103
% IX12.6 I103
% IX12.6 I103
...
There is a lot of data duplication in this table, and it is too much trouble to delete duplicate entries manually (30k items !!)
Please master to help solve it. Thank you first!
Reply

Use magic Report

0

Threads

17

Posts

15

Credits

Newbie

Rank: 1

Credits
15

 China

Post time: 2020-6-20 17:30:01
| Show all posts
1. Open the Excel file containing the duplicate records

2. Select all records and click the "Data" menu → "Filter → Advanced Filter" command

3. Tick the "Select records that are not duplicated" check box, and then change the filtering method to "Copy the filtering results to another location" and set the target area.
Reply

Use magic Report

1

Threads

2

Posts

3

Credits

Newbie

Rank: 1

Credits
3

 Invalid IP Address

 Author| Post time: 2020-6-26 11:15:01
| Show all posts
Thank you, it's done :)
Reply

Use magic Report

You have to log in before you can reply Login | Register

Points Rules

Contact us|Archive|Mobile|CopyRight © 2008-2020|verysource.com ( 京ICP备17048824号-1 )

Quick Reply To Top Return to the list