DataFilterAdvanced Filter

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

For more on this method see Debra Dalgleish's site

http://www.contextures.on.ca/xladvfilter01.html

Gord Dibben Excel MVP

On Fri, 26 Nov 2004 11:35:14 -0600, gabarrao
wrote:


Hello,

I have already done this. But even this way the list is too big. I
would like to find and automatic way.

Thanks very much,

Matheus