+ Reply to Thread
Results 1 to 3 of 3

Columns SUBSTRACTION or something

  1. #1
    Registered User
    Join Date
    08-25-2005
    Posts
    4

    Question Columns SUBSTRACTION or something

    Hi,
    I have this worksheet having 2 columns of numbers. I need help from you for getting this 3rd column meeting the following condition:

    - all numbers in column B that are NOT in column A

    Maybe it is easy, but I don't have a clue how can be done.
    Thanks

  2. #2
    Forum Expert
    Join Date
    09-09-2005
    Location
    England
    MS-Off Ver
    2007
    Posts
    1,500
    if you are prepared to do a few steps which wont take long

    in C1 put =IF(ISNUMBER(MATCH(B1,A:A,0)),"",B1)
    and copy this down column c to the end of column B where you numbers run out

    Select column B copy paste special and past as values on top of itsself to loose the formulas

    Now just sort column C to loose the blanks

    Regards

    Dav

  3. #3
    Registered User
    Join Date
    08-25-2005
    Posts
    4

    Thumbs up

    thank you thank you thank you thank you thank you thank you thank you

    What a great forum!! Quick answer, documented and effective answers.
    Forum and Excel rule.

    Did I say thank you? :D

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1