G
Guest
I have 4 columns of data, X co-ordinates, y co-ordinates, frame number, and
track number. The number of co-ordinates varies per track. I want to take the
first set of coordinates off the rest of the co-ordinates but as the number
varies I can't set a block of formulas where you take coordinate set 1 of the
first 30 values and set 31 of the next 30 values and so on. I think I need to
use the frame number to set which cell i use as the zero value. To do this i
would need to make a formula that uses a number in a cell (in my case frame
number) to alter a cell reference. Ie =A40-20 (Value in refernce cell) which
should give a new cell reference of a20 and not the value in a40 - 20. I hope
this makes sense.
John
track number. The number of co-ordinates varies per track. I want to take the
first set of coordinates off the rest of the co-ordinates but as the number
varies I can't set a block of formulas where you take coordinate set 1 of the
first 30 values and set 31 of the next 30 values and so on. I think I need to
use the frame number to set which cell i use as the zero value. To do this i
would need to make a formula that uses a number in a cell (in my case frame
number) to alter a cell reference. Ie =A40-20 (Value in refernce cell) which
should give a new cell reference of a20 and not the value in a40 - 20. I hope
this makes sense.
John