Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Duplicated data
Hi all
I have a large worksheet with Company names entered into Column A, however, the names are duplicated and the same one can appear up to 20 times. Is there a quick way I can ask Excel to search the column for me and leave just one instance of each name, rather than having to delete the duplicates manually? Thank you. Louise |
#2
|
|||
|
|||
Look at <Data<Filter <advanced Filter
another way use a helper column enter in B1 =Countif($A$1:$A1,A1) copy down to the bottom of your data. Sort columns A and B by Column B Delete all of the Column A and B Cells where B is greater than 1 "Louise" wrote: Hi all I have a large worksheet with Company names entered into Column A, however, the names are duplicated and the same one can appear up to 20 times. Is there a quick way I can ask Excel to search the column for me and leave just one instance of each name, rather than having to delete the duplicates manually? Thank you. Louise |
#3
|
|||
|
|||
Louise wrote:
Hi all I have a large worksheet with Company names entered into Column A, however, the names are duplicated and the same one can appear up to 20 times. Is there a quick way I can ask Excel to search the column for me and leave just one instance of each name, rather than having to delete the duplicates manually? Thank you. Louise Have a look he http://www.cpearson.com/excel/duplic...tingDuplicates |
#4
|
|||
|
|||
Thank you both for your help. The Advanced Filter solution worked perfectly.
Louise "Gordon" wrote: Louise wrote: Hi all I have a large worksheet with Company names entered into Column A, however, the names are duplicated and the same one can appear up to 20 times. Is there a quick way I can ask Excel to search the column for me and leave just one instance of each name, rather than having to delete the duplicates manually? Thank you. Louise Have a look he http://www.cpearson.com/excel/duplic...tingDuplicates |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Source Name Not Found | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
Pull Current Month's Data Out of List - Repost | Excel Discussion (Misc queries) | |||
Line Graph Data Recognition | Charts and Charting in Excel | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |