LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Can excel remove the duplicate rows in a spread sheet?

I have a spread sheet which has rows that are direct duplicates of one
another. That is: the key columns of the row are equal. There may be 11 rows
where the key columns are equal. Can Excel remove the second and suceeding
duplicate rows, leaving only one row?
 
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
HOW DO I REMOVE #VALUE FROM MY SPREAD SHEET Jas New Users to Excel 2 April 4th 23 12:59 PM
remove duplicate rows from specific data in a column; excel 2007 DS Excel Worksheet Functions 1 August 6th 08 08:16 PM
Duplicate records on a spread sheet J's quandary Excel Worksheet Functions 1 February 26th 07 08:52 PM
How do I remove an unwanted check box from an Excel spread sheet? Brondero Excel Discussion (Misc queries) 6 September 8th 06 02:42 AM
How do i delete duplicate rows in an Excel Spread Sheet sqirt Excel Worksheet Functions 1 February 8th 06 03:04 PM


All times are GMT +1. The time now is 08:04 AM.

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

About Us

"It's about Microsoft Excel"