Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: removing entries

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

    how do i remove phonenumbers in columnB from A?

  2. #2
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.





  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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.


  4. #4
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Try

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

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




  5. #5
    New Member
    Join Date
    Mar 2002
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  6. #6
    Rest in Peace
    Join Date
    Feb 2002
    Posts
    1,582
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Copy it down.



Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •