Can excel remove the duplicate rows in a spread sheet?

[Guest]

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?

 

[Tom Ogilvy]

See Chip Pearson's page on this topic:

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

 

[Bob Phillips]

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

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