Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Duplicate rows
I have a list that contains approx 4000 rows of info - school code,
school name, address and email. Some school codes are duplicated as a result of a workbook merge. I need to search through the information, find the duplicated rows and delete the row that DOES NOT contain an email address. How do I do this within Excel, or is this easier in Access? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Find duplicate rows then deleting them | Excel Worksheet Functions | |||
Is there an easy way to filter duplicate rows of data in excel? | Excel Discussion (Misc queries) | |||
How do I find duplicate rows in a list in Excel, and not delete it | Excel Discussion (Misc queries) | |||
How do I delete duplicate rows in an excel spreadsheet? | Excel Discussion (Misc queries) | |||
Keeping duplicate rows | Excel Worksheet Functions |