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.

A similar approach would be:

Please Login or Register  to view this content.

if your first row of data was in row 2.

Cheers,

If interested in VBA:

Please Login or Register  to view this content.

Just because I am over tired but can't resist playing, I've added a button for you to run your tests. Let me know if it fails.

Cheers!

I'm also interested in VBA:

Please Login or Register  to view this content.

Hot diggity snb,

Mordred's line count = 35
snb line count = 3

Very cool!