| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How to find dublicates in Excel and delete it?
Can not find out how to find duplicate records in large excel file and delete
duplicates by leaving just one unique record of each. Please help. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find dublicates in Excel and delete it?
In vs2007 it's a snap!
Simply highlight the data, and in the Data tab, you'll see a Remove Duplicates option. Just follow the procedure. Rob "bratka" wrote in message ... Can not find out how to find duplicate records in large excel file and delete duplicates by leaving just one unique record of each. Please help. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find dublicates in Excel and delete it?
What if a person is using v2003?
"RobN" wrote: In vs2007 it's a snap! Simply highlight the data, and in the Data tab, you'll see a Remove Duplicates option. Just follow the procedure. Rob "bratka" wrote in message ... Can not find out how to find duplicate records in large excel file and delete duplicates by leaving just one unique record of each. Please help. |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find dublicates in Excel and delete it?
Sorry....I've only got 2007 now. A 2003 user will need to hop in here.
Or, maybe look for removing duplicates in your version's Help. Rob "Joan" wrote in message ... What if a person is using v2003? "RobN" wrote: In vs2007 it's a snap! Simply highlight the data, and in the Data tab, you'll see a Remove Duplicates option. Just follow the procedure. Rob "bratka" wrote in message ... Can not find out how to find duplicate records in large excel file and delete duplicates by leaving just one unique record of each. Please help. |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find dublicates in Excel and delete it?
Thanks Rob and Joan! I'm using Excel 2003 and with your help located a software called Duplicates Remover at http://www.ablebits.com/excel-remove...ates/index.php and removed all duplicates using it :) Thanks again! Bratka G "RobN" wrote: Sorry....I've only got 2007 now. A 2003 user will need to hop in here. Or, maybe look for removing duplicates in your version's Help. Rob "Joan" wrote in message ... What if a person is using v2003? "RobN" wrote: In vs2007 it's a snap! Simply highlight the data, and in the Data tab, you'll see a Remove Duplicates option. Just follow the procedure. Rob "bratka" wrote in message ... Can not find out how to find duplicate records in large excel file and delete duplicates by leaving just one unique record of each. Please help. |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find dublicates in Excel and delete it?
This should help, though I didn't try it myself.
And it's free of charge. http://support.microsoft.com/kb/262277/EN-US/ "bratka" wrote: Can not find out how to find duplicate records in large excel file and delete duplicates by leaving just one unique record of each. Please help. |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How to find dublicates in Excel and delete it?
Chip Pearson has lots of techniques to work with duplicates:
http://www.cpearson.com/excel/Duplicates.aspx bratka wrote: Can not find out how to find duplicate records in large excel file and delete duplicates by leaving just one unique record of each. Please help. -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how do i find and delete all empty rows in an excel worksheet | Excel Worksheet Functions | |||
| Search for dublicates | Excel Worksheet Functions | |||
| how do i find and delete duplicates in excel worksheet? | Excel Discussion (Misc queries) | |||
| How can I use find and replace to delete a word in Excel? | Excel Discussion (Misc queries) | |||
| Can't find macro in an Excel file to delete it | Excel Discussion (Misc queries) | |||
Linear Mode
