extracting unique rows

DANmcc · Apr 20, 2005

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

thanks

dan

Gord Dibben · Apr 20, 2005

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/xladvfilter01.html#FilterUR

Gord Dibben Excel MVP

extracting unique rows

DANmcc

Gord Dibben