SitePoint Sponsor

User Tag List

Results 1 to 5 of 5
  1. #1
    SitePoint Member
    Join Date
    Aug 2004
    Location
    USA
    Posts
    17
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Smile Any Excel Pro's Around?

    I am trying to find a way to compare two columns of numbers. Each column contains about 2,500 rows of numbers and I want to know what numbers appear in one column and not the other.

    Ex:

    Column A Column B

    1234 3424
    4324 4324
    5435 5345
    6564 1234
    3242 6546
    5435 7657


    I want to know two things:

    1. What numbers appear in Column A and not in Column B.
    2. What numbers appear in Column B and not Column A.

    Is there anything out there that can do this? Most things I have found so far compare the rows side by side. I dont care about the order the numbers are in.

    Thanks

  2. #2
    Non-Member Kenneth's Avatar
    Join Date
    Sep 2004
    Location
    Wisconsin
    Posts
    9
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Have you tried creating a simple C#.NET application, importing the numbers into two seperate Arrays[] and running comparison code on the Arrays[] ?

    Pretty sure that will work.

  3. #3
    SitePoint Zealot
    Join Date
    Jun 2002
    Location
    Wiltshire, England
    Posts
    106
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    What i would do is do two vlookups

    Insert a column in front of the 1st row of data and look for b in col c, then in a new col after the second col look for c in col b. This would then highlight stuff which is missing for the other col.

    Hope that makes sense
    Last edited by bigstu; Sep 28, 2004 at 07:20. Reason: spelling

  4. #4
    SitePoint Enthusiast
    Join Date
    Sep 2004
    Location
    Glastonbury, CT
    Posts
    59
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Red face

    To solve that problem, you can simply widen the columns by moving the cursor onto the line that separates the columns, and then draging it to the right to widen it.

    ltng92

  5. #5
    SitePoint Enthusiast kaos's Avatar
    Join Date
    Jun 2004
    Location
    CANADA
    Posts
    44
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Can you write a macro something like

    for each a in Range("A1:A2500")
    for each b in Range("B1:B2500")
    if a.value == b.value
    'show it, change back ground color or something
    end if
    next b
    next a

    I think this should work


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
  •