Using the COLUMN Function

Summary: The COLUMN worksheet function returns the column number of whatever column it appears within. This can be handy for some formulas, as described in this tip. (This tip works with Microsoft Excel 97, Excel 2000, Excel 2002, and Excel 2003.)

Excel includes a nifty little worksheet function that lets you determine the column number of a particular cell reference. Normally columns are designated as A, B, C, and so on, but the COLUMN function returns a numeric value that represents the column. Thus, column A is 1, B is 2, and so on.

You can use the function in the following manner:

=COLUMN(InputRange)

In this instance, the function returns the column of the range named InputRange. You can also use the function without any optional range reference, as follows:

=COLUMN()

When used in this manner, COLUMN returns the column number of the cell in which the COLUMN function is used. Thus, if cell C5 contained =COLUMN(), then the function would return a value of 3.

ExcelTips is your source for cost-effective Microsoft Excel training. This tip (2305) applies to Microsoft Excel versions: 97 | 2000 | 2002 | 2003

Got the Time? Understanding the ins and outs of working with times and dates can be confusing. Remove the confusion--ExcelTips: Times and Dates is an invaluable resource for learning how best to work with times and dates.

Check out ExcelTips: Times and Dates today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using the COLUMN Function