Which column in an array of columns
 

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

Which column in an array of columns
 

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

HTH,
Bernie
MS Excel MVP


"DK" wrote in message ...
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

Which column in an array of columns
 

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

"Bernie Deitrick" <deitbe @ consumer dot org wrote in message
...
=COLUMN()-COLUMN($C$1)+1

HTH,
Bernie
MS Excel MVP


"DK" wrote in message
...
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