Adjusting formulas to accommodate variable size of input data
Posted on 2011-03-23
Attached is a file where I need to change a given shape based on certain parameters.
The input data shall be copied from another software to columns A and B below row 10
Based on values from C1 to C6 a new shape has to be generated. (C1 and C2 shall be manually entered)
The formulas for the new shape is entered in columns D and E. Presently only column D changes.
The problem is that the size of the input data varies and so does the location of '0' and the formulas depend on the position of zero. (I have provided a second set of data for checking purposes in columns A and B)
I would like to modify the formulas so that the shape is correctly modified. This shape modification can be visualised by changing the values in C1 and C2 as suggested in the file.
Note: This has to be done without VBA.