Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I eliminate duplicae records in excel file
I have a large excel file with 12K records of companies, addresses., etc I
want to eliminate duplications where company and city are duplicated but not necessarily street addresses. How do I do so? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I eliminate duplicae records in excel file
Hi,
Look here CPearson has a macro to do that, go to the middle of the page http://www.cpearson.com/excel/deleting.htm "Big B" wrote: I have a large excel file with 12K records of companies, addresses., etc I want to eliminate duplications where company and city are duplicated but not necessarily street addresses. How do I do so? |
#3
|
|||
|
|||
Quote:
1. Select all the rows, including the column headers, in the list you want to filter. 2. Click the top left cell of the range, and then drag to the bottom right cell. 3. On the Data menu, point to Filter, and then click Advanced Filter. 4. In the Advanced Filter dialog box, click Filter the list, in place. 5. Select the Unique records only check box, and then click OK. The filtered list is displayed and the duplicate rows are hidden. 6.On the Edit menu, click Office Clipboard. The Clipboard task pane is displayed. 7.Make sure the filtered list is still selected, and then click Copy . The filtered list is highlighted with bounding outlines and the selection appears as an item at the top of the Clipboard. 8.On the Data menu, point to Filter, and then click Show All. The original list is re-displayed. Press the DELETE key. The original list is deleted. In the Clipboard, click on the filtered list item. The filtered list appears in the same location as the original list. all the best
__________________
Thanks Bala |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how do I export excel records to csv file? | Excel Discussion (Misc queries) | |||
how do I download a csv file with 100,000 records into excel? | Excel Discussion (Misc queries) | |||
Excel should let me eliminate "duplicate records" in a column | Excel Discussion (Misc queries) | |||
Eliminate Excel copies that have no file type | Excel Worksheet Functions | |||
eliminate white space in Excel file | Excel Discussion (Misc queries) |