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

Your Data, Your Way! Want the greatest control possible over how your data appears on the page? Excel's custom formats can provide that control, and ExcelTips: Custom Formats can unlock the secrets to creating your own custom formats.

Check out ExcelTips: Custom Formats today!

Helpful Links

Newest Tips

Subscribe

RSS Feeds

Using the COLUMN Function