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

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

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

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