Thread: Duplicate Rows
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
dberger16 dberger16 is offline
external usenet poster
 
Posts: 11
Default Duplicate Rows

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