Results 1 to 10 of 19

Thread: compare column a to b and b to a

Hybrid View

Previous Post Previous Post   Next Post Next Post
  1. #1
    Member ayazgreat's Avatar
    Join Date
    Mar 2012
    Posts
    86
    Rep Power
    14
    An example a column has values 1,3,4,6,9,11,12 and b column has values 1,2,3,7,9,10,13
    When compare col b from col a so result is 2,7,10,13
    When compare col a to col b so result is 4,6,11,12

  2. #2
    Forum Guru Rick Rothstein's Avatar
    Join Date
    Feb 2012
    Posts
    662
    Rep Power
    15
    Quote Originally Posted by ayazgreat View Post
    An example a column has values 1,3,4,6,9,11,12 and b column has values 1,2,3,7,9,10,13
    When compare col b from col a so result is 2,7,10,13
    When compare col a to col b so result is 4,6,11,12
    Are these examples of real values you have? If so, what is the maximum value that can appear in a column? Depending on your two answers to these questions, there may be a relatively simple code solution. However, if those are values that you actually have, could you post an example with the real values? Again, depending on what they are, there again, may be a relatively simple code solution.

Similar Threads

  1. Replies: 10
    Last Post: 05-23-2013, 12:30 PM
  2. Converting a Column Number to a Column Letter
    By Rasm in forum Excel and VBA Tips and Tricks
    Replies: 6
    Last Post: 12-17-2012, 02:29 AM
  3. Replies: 3
    Last Post: 08-05-2012, 09:16 PM
  4. Replies: 1
    Last Post: 11-11-2011, 02:06 PM
  5. Compare two worksheets and List Differences
    By excel_learner in forum Excel Help
    Replies: 1
    Last Post: 11-02-2011, 10:03 PM

Posting Permissions

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