Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparison of columns and calculate differences
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Comparison of columns and calculate differences
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. -- Biff Microsoft Excel MVP "Rob" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Differences between columns | Excel Worksheet Functions | |||
Formula to calculate differences between dates?? | Excel Discussion (Misc queries) | |||
How to calculate Date & Time differences | Excel Worksheet Functions | |||
Calculate differences between age | Excel Discussion (Misc queries) | |||
calculate date differences in years and months | Excel Worksheet Functions |