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?

Can excel remove the duplicate rows in a spread sheet?
 

See Chip Pearson's page on this topic:

http://www.cpearson.com/excel/duplicat.htm

--
Regards,
Tom Ogilvy
"Robert Moritzky" <Robert wrote in
message ...
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?

Can excel remove the duplicate rows in a spread sheet?
 

Take a look at the advanced filter. Debra Dalgleish has a good page on

http://www.contextures.com/xladvfilter01.html#FilterUR

--

HTH

RP

"Robert Moritzky" <Robert wrote in
message ...
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?