| 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 |
| 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 | |||
Threaded Mode
