extracting unique rows

Hi,
I am trying to remove duplicate rows(consisting of 8 columns or horizontal
cells).
any ideas?

thanks

dan

Data>Filter>Advanced Filter.

Check "unique records" and "copy to another location"

For more details and pictures see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfi....html#FilterUR


Gord Dibben Excel MVP

On Tue, 19 Apr 2005 17:00:01 -0700, DANmcc <[email protected]>
wrote:

>Hi,
>I am trying to remove duplicate rows(consisting of 8 columns or horizontal
>cells).
>any ideas?
>
>thanks
>
>dan