|
Member Login:
|
|
 |
March 24th, 2005
|
Top | #1 |
OSNN Veteran Addict
Joined: March 2002
Location: Birmingham, UK
Posts: 1,692
Reputation: 1420
Power: 155 |
Remove duplicate entries in Excel
I've got an excel spreadsheet full of data that I have compiled from 3 other spreadsheets. A lot of the data in these spreadsheets are present in all 3, so now the one large file I have contains duplications of certain lines. Is there anyway to run some sort ot batch process or script that will remove any extra instances of every row of data other than the first occurance of the data in that row? Thanks in advance! 
|
|
|
|
March 24th, 2005
|
Top | #2 |
I'm sorry Hal...
Joined: January 2002
Location: England
Posts: 5,514
Reputation: 1210
Power: 194 |
Re: Remove duplicate entries in Excel
Highlight the columns, go to data->filter->advanced filter -> tick "unique records only" then with filter inplace or copy to a new location. then you done
|
|
|
|
|
| Bookmarks |
«
Previous Thread
|
Next Thread
»
| Thread Tools | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| Cannot remove entries in add/remove panel | Heeter | Windows Desktop Systems | 42 | March 29th, 2005 4:49pm |
| This post is a duplicate | perris | Site Problems & Feedback | 6 | July 11th, 2004 7:05am |
| Duplicate Drivers | coathanger007 | Windows Desktop Systems | 1 | November 1st, 2003 11:42pm |
| Remove Right-Click Context Menu Entries? | Immune_Jam | Windows Desktop Systems | 1 | June 18th, 2003 5:46pm |
| Remove TaskBar "Customize Notifications" Entries | i_pedal | Windows Desktop Systems | 5 | June 1st, 2002 4:29am |
Page generated in 0.07 seconds with 15 queries.
