It will if you enter it as an array formula (CSE).
--
David Biddulph

"Dave F" wrote in message
...
I'm not sure that answers the question. I entered the formula in cell B1.
Extending it do the right does not return 2,3,4 etc.

"David Biddulph" wrote:

Help says:
"If reference is a range of cells, and if COLUMN is entered as a
horizontal
array, COLUMN returns the column numbers of reference as a horizontal
array."
If you enter only the first element of that horizontal array, you'll get
the
first element of the result, i.e. COLUMN(A9), which is 1. If you extend
it
to a horizintal array, you'll get 1, 2, 3, .... etc.
--
David Biddulph

"Dave F" wrote in message
...
This function returns 1: =COLUMN(9:9). I would expect it to return an
error,
being that row 9 is not, in fact, a column.

What's happening here?