I need to calculate difference between figures in “Column D” and “Column C” based on their location from a predefined value in A1 which appears in “Column B”.
With some effort I arrived at a formula which gives me Undesired /wrong result in a “Column F”.
The desired result which manually solved is presented in “Column G”. Basically, the difference between “Column D” and “Column C” need to be equidistant in opposite directions from the row in which “value A1” appears in “Column B”
I request anyone for a formula which can do the same automatically.
The problem file is attached.