View Single Post
  #2   Report Post  
Biff
 
Posts: n/a
Default

Hi!

So what happens with the values that will be displaced by "moving"
"matching" values? Will there be matches for all the values in column C?

It looks like the correlation is the time in column B that matches the time
in column A. So, nothing happens to A1,B1 and C1?

Am I even remotely close? <LOL

Biff

"Jeff" wrote in message
...
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