LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Find duplicate rows then deleting them SSHO_99 Excel Worksheet Functions 4 May 4th 07 11:17 AM
Is there an easy way to filter duplicate rows of data in excel? Yumin Excel Discussion (Misc queries) 1 October 7th 05 08:15 PM
How do I find duplicate rows in a list in Excel, and not delete it Matthew in FL Excel Discussion (Misc queries) 2 June 15th 05 09:11 PM
How do I delete duplicate rows in an excel spreadsheet? jsm Excel Discussion (Misc queries) 4 May 14th 05 07:48 PM
Keeping duplicate rows Daniell Excel Worksheet Functions 2 April 18th 05 06:56 AM


All times are GMT +1. The time now is 05:31 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"