Comparison of columns and calculate differences

R

Rob

I have three columns. Column A & B represent the order in which items have to
be made. Column C represents the difference between the order in the two
columns in terms of how many rows the value in Column B has moved forward or
backward relative to Column A. How can I calculate the value of the
difference and populate column C ?

Col Col Col
A B C
1127 1129 +1
1129 1130 +1
1130 1132 +3
1102 1102 0
1131 1131 0
1132 1133 +1
1133 1135 +1
1135 1137 +2
1062 1138 +2
1137 1062 -1
1138 1141 +1
1141 1143
 
T

T. Valko

Doesn't look like too many people understand what you want to do. Myself
included!

If you can explain the logic of how you arrive at the results maybe someone
will be able to figure it out.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Comparison of Columns 3
Macro for comparing columns and highlighting matching/differences 13
Copy pair of columns 3
Two Toggle Buttons to calculate Day(s) Hour(s) Minute(s) between entry time 1
Counting unique values in multiple columns 4
League table 3
Six columns randon no.'s no dupes 6
Cell reference formula problem 5

Top