| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
EXCEL find adn delete
I've got a 7 column EXCEL sheet. I want to eliminate duplicate entries. The
problem is that I need to locate duplicate last names in one column and then examine the entries in each line before deleting one of the lines. Is this possible? Or do I have to go down each record manually? Thank you. -- Templar |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL find adn delete
Tag them then examine them, then delete
http://www.cpearson.com/excel/Duplicates.aspx -- Regards, Peo Sjoblom "Templar" wrote in message ... I've got a 7 column EXCEL sheet. I want to eliminate duplicate entries. The problem is that I need to locate duplicate last names in one column and then examine the entries in each line before deleting one of the lines. Is this possible? Or do I have to go down each record manually? Thank you. -- Templar |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL find adn delete
Could you be a little more specific as to how to do this?
-- Templar "Peo Sjoblom" wrote: Tag them then examine them, then delete http://www.cpearson.com/excel/Duplicates.aspx -- Regards, Peo Sjoblom "Templar" wrote in message ... I've got a 7 column EXCEL sheet. I want to eliminate duplicate entries. The problem is that I need to locate duplicate last names in one column and then examine the entries in each line before deleting one of the lines. Is this possible? Or do I have to go down each record manually? Thank you. -- Templar |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
EXCEL find adn delete
Please read the instructions at the link provided by Peo. Could you be a little more specific as to how to do this? -- Templar "Peo Sjoblom" wrote: Tag them then examine them, then delete http://www.cpearson.com/excel/Duplicates.aspx -- Regards, Peo Sjoblom "Templar" wrote in message ... I've got a 7 column EXCEL sheet. I want to eliminate duplicate entries. The problem is that I need to locate duplicate last names in one column and then examine the entries in each line before deleting one of the lines. Is this possible? Or do I have to go down each record manually? Thank you. -- Templar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How to find dublicates in Excel and delete it? | Excel Discussion (Misc queries) | |||
| how do i find and delete all empty rows in an excel worksheet | 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
