Actually now I understand your explanation.

Dave
--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"Dave F" wrote:

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.


--
A hint to posters: Specific, detailed questions are more likely to be
answered than questions that provide no detail about your problem.


"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?