Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi,
My new responsibility at work is to align (sequence) the values from column C to match column A while using column B as the set criteria (key?). For example, the value from b2-c2 - 14 would move down two rows to be in alignment with A4. To continue, the value from b3-c3 - 45 would move down four rows to be in alignment with A7. Is there a formula to simplify this process? A B C 8:00 8:00 56 8:30 9:30 14 9:00 11:00 45 9:30 11:30 24 10:00 1:00 84 10:30 2:00 7 11:00 4:00 65 Thank you for reviewing this situation. If I can provide any additional information, please let me know. Jeff |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Sort pages? | Excel Discussion (Misc queries) | |||
Append the data given in diff sheets of an Excel File to one sheet | Excel Worksheet Functions | |||
Why " data analysis plus " override " data analysis " once instal. | Excel Worksheet Functions | |||
SUMPRODUCT Formula to Count Row of data Below Matched Criteria | Excel Worksheet Functions | |||
Running Data Table using an input that triggers DDE linked data | Excel Discussion (Misc queries) |