Combining index, address, reference-type formulae

Hi,

Please see the attachment.

The file is a combination of several txt files, each one with the same header (of 4 lines), and the same format.

The purpose of the sheet is to calculate the offset in the X and Y direction from the origin. This is calculated by subtracting each row's values from the origin. If I just did it for one, I could obviously use the $ to tell the formula to keep the cell reference static.

However, with several of these combined files (there are 160 in my real file), it wouldn't work as I would need to move the static cell reference each time I moved past a new header (onto a new object).

Is there some way to use the row reference to make the static reference stay on the first row of each dataset? (i.e. at the bottom of each header, and at the first XY point)


Please ask if you need clarification, its hard to explain!