Duplicate Rows
in [General]
|
Prev: String-in-Cell .... too long??? Word Wrap not working...PLEAS
Next: Text cut off in Text Box. (Not a quantity issue)
From: dberger16 on 19 Feb 2010 15:04 I have many duplicate rows in my spreadsheet. I would like to delete duplicates rows, but keep one of the rows of duplicates. How best can I do this and thank you! -- DaveB dberger16(a)comcast.net
From: Russell Dawson on 19 Feb 2010 15:24 Data Tools - Remove duplicates - You may specify which columns are interrogated for duplicate info. Please tick Yes if this was helpful to you. -- Russell Dawson Excel Student "dberger16" wrote: > I have many duplicate rows in my spreadsheet. I would like to delete > duplicates rows, but keep one of the rows of duplicates. > > How best can I do this and thank you! > -- > DaveB > dberger16(a)comcast.net
From: dberger16 on 19 Feb 2010 15:35 Thanks, all of my rows that are dups have the same columns. I want to keep 1 of the duplicate rows. -- DaveB "Russell Dawson" wrote: > Data Tools - Remove duplicates - You may specify which columns are > interrogated for duplicate info. > > Please tick Yes if this was helpful to you. > -- > Russell Dawson > Excel Student > > > "dberger16" wrote: > > > I have many duplicate rows in my spreadsheet. I would like to delete > > duplicates rows, but keep one of the rows of duplicates. > > > > How best can I do this and thank you! > > -- > > DaveB > > dberger16(a)comcast.net
From: dberger16 on 19 Feb 2010 15:38
Russell, I want to keep on of the duplicate rows, and all columns are the same for the dups. I just need to understand how to remove all dups but 1 row. Thanks. -- DaveB "Russell Dawson" wrote: > Data Tools - Remove duplicates - You may specify which columns are > interrogated for duplicate info. > > Please tick Yes if this was helpful to you. > -- > Russell Dawson > Excel Student > > > "dberger16" wrote: > > > I have many duplicate rows in my spreadsheet. I would like to delete > > duplicates rows, but keep one of the rows of duplicates. > > > > How best can I do this and thank you! > > -- > > DaveB > > dberger16(a)comcast.net |