advanced filtering

  • Thread starter Thread starter jim.davis
  • Start date Start date
J

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!
 
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!
 
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.
 
-----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)"
.
Click to expand...
 
-----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)"
Click to expand...



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
 
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.
 
Back
Top