|
Removing Duplicate Rows
HI, I HAVE A FILE WITH 11,000 ROWS, MANY OF WHICH ARE DUPLICATES. FILE ONLY HAS 2 COLUMNS. IS THERE AN EASY WAY TO REMOVE ALL DUPLICATE ROWS? THANKS IN ADVANCE FOR YOUR KIND HELP. MATT -- bvinternet ------------------------------------------------------------------------ bvinternet's Profile: http://www.excelforum.com/member.php...o&userid=25525 View this thread: http://www.excelforum.com/showthread...hreadid=389619 |
Yes, explore the Advanced filter (menu DataFilterAdvanced Filter)
Regards, KL "bvinternet" wrote in message ... HI, I HAVE A FILE WITH 11,000 ROWS, MANY OF WHICH ARE DUPLICATES. FILE ONLY HAS 2 COLUMNS. IS THERE AN EASY WAY TO REMOVE ALL DUPLICATE ROWS? THANKS IN ADVANCE FOR YOUR KIND HELP. MATT -- bvinternet ------------------------------------------------------------------------ bvinternet's Profile: http://www.excelforum.com/member.php...o&userid=25525 View this thread: http://www.excelforum.com/showthread...hreadid=389619 |
| All times are GMT +1. The time now is 08:23 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com