I have a table with 10 fields. The poistion of each field changes on a daily basis. Ie what is in cells A1 & A2 today may be located in cells A10 & a6 tomorrow. The data is coming from a 3rd party system that I cannot alter to lock the fields into place that that I have fixed references from which to make a formula.
I am trying to find a way to lock on to the field heading rather than the specific cell in a spreadsheet.
So , I want a formula like the following:
instead of Total = A1+A2,
I need something like:
Total = Part1CalculationColumnField + Part2CalculationColumnField
Is there a way to do this?
Bookmarks