Hi Werner,

To determine the offset of -2 columns from G to E, you can use the

Formula:

MATCH 


function in Microsoft Excel. The MATCH function searches for a specified value in a range of cells and returns the relative position of that value within the range.

Here's how you can use the MATCH function to find the offset of -2 columns from G to E:

1. Select cell G2 where you want to enter the formula.
2. Type the following formula:
   Formula:

   =MATCH("X",$A$1:$F$1,-1) 

3. Press Enter.

This formula searches for the value "X" in the range $A$1:$F$1 from right to left (-1). The MATCH function returns the relative position of the last "X" in the range, which is 4 in this case.

1. Subtract 2 from the result to get the offset of -2 columns from G to E. In this case, the offset is 2.

So, to reference the last "X" in column E from cell G2, you can use the following formula:

Formula:

=E2-offset 


, where "offset" is the result of the MATCH function minus 2. In this case, the formula would be:

Formula:

=E2-2 


.