about column() 1

[jslmvl]

Hi,

What is column(1:1)? I just cannot find help.

Thank you in advance.

 

[GlennUK]

From Help:

COLUMN

Returns the column number of the given reference.

Syntax

COLUMN(reference)

Reference is the cell or range of cells for which you want the column number.

If reference is omitted, it is assumed to be the reference of the cell in which the COLUMN function appears.

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.

Reference cannot refer to multiple areas.

Cheers, Glenn.

Beauty is in the eye of the beerholder.

 

[AnotherHiggins]

What are you talking about? We can't read your mind.

Please provide some context. Where did you come across this?

column(1:1) doesn't make a whole lot of sense. In an Excel worksheet function, column(1:1) will return 1. That's because the Column function returns the column number of a range. 1:1 refers to the entire first row, and cell A1 is the top left cell of that range. And since Column A is the first column, you get 1.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[jslmvl]

anotherhiggins,

Actually I want to know what column(1:1) returns and you have explanained that. Thanks a lot.
But, can you give me another example to show me "3:3 returns to the entire 3nd row"?

 

[AnotherHiggins]

Put values in the third row. In a different row*, type in =SUM(3:3). This will sum the values in row 3.

Consider =Sum(A1:C3).
That, clearly, refers to cells A1:C3.

Similarly, you can leave out either the column or the row portions of a range.
A:C refers to columns A, B and C in their entirety.
1:3 refers to rows 1, 2, and 3 in their entirety.


*You must place the formula in a different row to avoid a circular reference.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[jslmvl]

That is a great help for me. I knew A:C and always thinking why there if no such thing for rows....