Skip to content
xlsoffice. All Rights Reserved
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Lookup and Reference Examples

  • Lookup entire row in Excel
  • Get nth match with INDEX / MATCH in Excel
  • How to use Excel OFFSET function
  • How to use Excel LOOKUP Function
  • How to get first column number in range in Excel

Data Analysis Examples

  • How to count table columns in Excel
  • Remove Duplicates Example in Excel
  • Excel Bar Chart
  • Excel Pie Chart
  • Add Outline to Data in Excel

Data Validation Examples

  • Excel Data validation allow uppercase only
  • Excel Data validation date in specific year
  • Excel Data validation number multiple 100
  • Excel Data validation must begin with
  • Excel Data validation must contain specific text

How to use Excel COLUMN Function

by

This Excel tutorial explains how to use the COLUMN function with syntax and examples.

Excel COLUMN function Description

The Microsoft Excel COLUMN function returns the column number of a cell reference.

The COLUMN function is a built-in function in Excel that is categorized as a Lookup/Reference Function. It can be used as a worksheet function in Excel. As a worksheet function, the COLUMN function can be entered as part of a formula in a cell of a worksheet.

Worked Example:   How to get first column number in range in Excel
Worked Example:   How to get address of last cell in range in Excel

Explanation: The Excel COLUMN function returns the column number for a reference. For example, COLUMN(C5) returns 3, since C is the third column in the spreadsheet. When no reference is provided, COLUMN returns the column number of the cell which contains the formula.

Worked Example:   Count rows with at least n matching values

Syntax

The syntax for the COLUMN function in Microsoft Excel is:

COLUMN( [reference] )

Returns

The COLUMN function returns a numeric value.

Post navigation

Previous Post:

How to use Excel CHOOSE Function

Next Post:

How to use Excel COLUMNS Function

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others
  • How to split text string at specific character in Excel
  • Get first name from full name — Manipulating NAMES in Excel
  • Convert Numbers to Text in Excel
  • How to get page from URL in Excel
  • CODE function: Description, Usage, Syntax, Examples and Explanation
  • How to show last updated date stamp in Excel
  • Convert date to month and year in Excel
  • NOW function: Description, Usage, Syntax, Examples and Explanation
  • Convert decimal minutes to Excel time
  • WORKDAY.INTL function: Description, Usage, Syntax, Examples and Explanation
  • How to calculate simple interest in Excel
  • How to set check register balance in Excel
  • DISC function: Description, Usage, Syntax, Examples and Explanation
  • RRI function: Description, Usage, Syntax, Examples and Explanation
  • IPMT function: Description, Usage, Syntax, Examples and Explanation
Acronyms, Abbreviations, Initialism & What They Stand For
© 2021 xlsoffice. All Rights Reserved | Teal Smiles