How do I use COLUMN in Excel?
Use COLUMN when you want to return a column number. Enter Reference in that order, then add optional arguments when needed.
Excel Function
COLUMN
Returns column number of a reference.
COLUMN([reference])Arguments
reference
OptionalSpecify a single cell reference.
Practice Preview
Use COLUMN to return the result with these settings (Reference: B2 (cell B2 (Product Name in column B))).
Example Table
| # | AProduct ID | BProduct Name | CPrice | DStock |
|---|---|---|---|---|
| 2 | P001 | Apple | 120 | 80 |
| 3 | P002 | Banana | 98 | 120 |
| 4 | P003 | Notebook | 450 | 35 |
| 5 | P004 | Pen | 300 | 60 |
| 6 | P005 | Grapes | 150 | 45 |
| 7 | P006 | Ruler | 250 | 20 |
| 8 | P007 | Peach | 86 | 55 |
How to Use (Formula)
=COLUMN(B2)Result
2
Practice This Function
COLUMN FAQ
Where can I practice COLUMN?
Use the "Start Function Practice" button to jump straight into COLUMN drills.
What arguments does COLUMN use?
The main arguments are Reference. Start with the required ones, then add optional arguments if needed.