removing entries

[dilli]

i have a long column of phonenumbers(A) and a shorter column(B)

how do i remove phonenumbers in columnB from A?

 

[Dave Hawley]

Hi Dilli

Best way (and quickest) is this.

Copy # in Column B to the end of Column A so that you have one long list of numbers.Ensure you have a heading in Cell A1

Select any single cell in column and go to Data>Filter>Advanced filter. Choose "Copy to another location" Choose a range to "Copy To:" tick "Unique Records only" and click Ok


That's it.

 

[dilli]

Tried it, but it led to me getting another list with ALL uniques from A + B , what i seek is a list of listA - listB.

 

[Dave Hawley]

Try

=IF(COUNTIF($B:$B,A1)=0,A1,"")

In column C then sort and change to values via Paste Special.

 

[dilli]

that will only write a1 if not found in columnB right? , but i need it to cover whole column A , not just a1.

 

[Dave Hawley]

Copy it down.