Results 1 to 9 of 9

Scanning for shifted values in different columns

Threaded View

  1. #1
    Registered User
    Join Date
    10-03-2010
    Location
    Malaysia
    MS-Off Ver
    Excel 2007
    Posts
    6

    Scanning for shifted values in different columns

    Hi everyone,

    I would really appreciate your help guys, I am a programmer, but not familiar with Excel's VBA.

    Let's say I have two columns as below:

    A A
    B B
    C C
    D E
    E D
    F F

    As you can see, the content of the two columns are same, but not the arrangement, I want a third column to scan each value of the second column, and detect if it was placed at the same place it was in column one, if not, how many *rows* it has shifted.

    For example the third column would look like this:

    A A 0
    B B 0
    C C 0
    D E -1
    E D 1
    F F 0


    I was trying to write a macro for it, but as I said I am not familiar with VBA and how to communicate and access the sheet's content.

    Your help is much appreciate everyone. What is the best way to do that? A formula, macro anything that gets the job done is great!

    Thank you.
    Last edited by luinox86; 06-14-2011 at 02:27 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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