Which column in an array of columns

[DK]

Dear Experts,
What is the formula that would return the current column index within an
array of columns?
I appologize if my terms are incorrect.
Example: In an array or range of columns from C:F, the formula in column D
would = 2, Column F = 4.
Thanks.
DK

 

[Bernie Deitrick]

=COLUMN()-COLUMN($C$1)+1

HTH,
Bernie
MS Excel MVP

 

[DK]

Thanks Bernie,
I see that I only need to identify the starting column and not the range of
columns.
Thanks again.
DK