This will give you the column of that cell, but what do you want to do with
it?

MAX(IF(A1:F1="X",COLUMN(A1:F1)))

which is an array formula, it should be committed with Ctrl-Shift-Enter, not
just Enter.
Excel will automatically enclose the formula in braces (curly brackets), do
not try to do this manually.
When editing the formula, it must again be array-entered.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Werner Rohrmoser" wrote in message
...
Hello,

I have a row, which is populated with a few "X" letters.
Dependent where an "X" is located I'd like to do a calculation.

Example:

A B C D E F G
X X X X

Now I make a calculation in "G2", which uses values out of the last
column
with an "X", in my case out of column "E".
How can I determine the offset of -2 columns from G to E?

Regards
Werner