advanced filtering

[jim.davis]

I need to do a "reverse" advanced filtering. In other
words, I need to highlight a column of names and seperate
the "non" duplications. When I do the advanced filtering
now - all I can get is what is duplicated. I want the non
dupes to appear in a seperate column. Thanks to anyone
in advance for your help!

 

[Domenic]

Hi Jim,

Select your column of names, including your header
Data > Filter > Advanced Filter
Check "Copy to another location"
Enter your new location in the "Copy to" box
Check "Unique records only"
Click OK

Hope this helps!

 

[bj]

One way to do it is to insert a column next to the one you
are interested in (assume A2 is first data cell)
in Cell B2 enter "if(and(A2<>A1,A2<>A3),1,0)"
Use autofilter on Column B to select all the "1"s copy
these cells and paste to another location.

 

[jim]

-----Original Message-----
Hi Jim,

Select your column of names, including your header
Data > Filter > Advanced Filter
Check "Copy to another location"
Enter your new location in the "Copy to" box
Check "Unique records only"
Click OK

Hope this helps!

"(e-mail address removed)"
.

 

[jim]

-----Original Message-----
Hi Jim,

Select your column of names, including your header
Data > Filter > Advanced Filter
Check "Copy to another location"
Enter your new location in the "Copy to" box
Check "Unique records only"
Click OK

Hope this helps!

"(e-mail address removed)"

Domenic - what I'm trying to do is seperate the names
that appear only once - not the ones that appear multiple
times - I'd like to copy the one time names to another
column.. >. thanks jim

 

[Debra Dalgleish]

In the criteria area, leave the heading cell blank
In the cell below, enter a formula that refers to the column that
contains the names, and the first data cell in that column, e.g.:
=COUNTIF(A:A,A2)=1

When you run the Advanced Filter, select the column of names as the List
Select the blank heading cell, and the cell with the formula, as the
criteria range.