Delete duplicate and original row
 

Is there a way to delete rows that are duplicates (both the duplicate row and
the original row), so that I am left with only rows that are completely
unique within a spreadsheet?

Delete duplicate and original row
 

Duplicated in one column or many?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JStiehl" wrote in message
...
Is there a way to delete rows that are duplicates (both the duplicate row
and
the original row), so that I am left with only rows that are completely
unique within a spreadsheet?

Delete duplicate and original row
 

At most, there would be two rows with the information in all 29 columns of
the rows being identical.

"Don Guillett" wrote:

Duplicated in one column or many?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JStiehl" wrote in message
...
Is there a way to delete rows that are duplicates (both the duplicate row
and
the original row), so that I am left with only rows that are completely
unique within a spreadsheet?

Delete duplicate and original row
 

Like pulling teeth here.
AND, would these blanks always be located in the same column(s)
Maybe send your file to me with this msg and COMPLETE explanation.
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JStiehl" wrote in message
...
At most, there would be two rows with the information in all 29 columns of
the rows being identical.

"Don Guillett" wrote:

Duplicated in one column or many?

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"JStiehl" wrote in message
...
Is there a way to delete rows that are duplicates (both the duplicate
row
and
the original row), so that I am left with only rows that are completely
unique within a spreadsheet?