COLUMN in Excel: Column Numbers and Position-Based Formulas

• Introduced: Original introduction release not established by the official history reviewed.
• Availability: official help lists Excel for Microsoft 365, Excel for Microsoft 365 for Mac, Excel 2024, Excel 2024 for Mac, Excel 2021, Excel 2021 for Mac, Excel 2019, Excel 2016.
• Checked: October 14, 2026; official COLUMN reference. Documentation check; examples independently calculated, not native-tested.

=COLUMN([reference])

The reference is optional and cannot contain multiple areas. A single-cell reference returns that cell’s worksheet column number, regardless of the value stored there. COLUMNS, with an S, measures the width of a range instead. Official COLUMN reference

A range reference can return several column numbers in array context. The help also describes a leftmost-column result when the formula is not entered as an array, so entry mode and Excel version matter for a multi-column argument.

Put 250 in H3, then enter this formula in B2:

=COLUMN(H3)

Expected result: 8, because H is the eighth worksheet column. The stored number 250 is not the answer. Clearing H3 does not change the coordinate.

In D10 enter:

=COLUMN()

Expected result: 4, because the formula is in column D. Its worksheet row 10 does not affect the result.

Put the labels January, February, March and April in D1:G1. In D2 enter:

=COLUMN(D1)-COLUMN($D$1)+1

Fill across to G2. Expected values are 1, 2, 3, 4. The source references advance from D1 through G1, while the absolute starting reference remains D1.

These are relative positions within this four-month display, not calendar month numbers inferred from the text. If the headings begin with April instead, the same position formula still starts at one.

In D4 enter and fill across to G4:

=MOD(COLUMN(),2)=0

Expected results: TRUE, FALSE, TRUE, FALSE, because columns D–G have numbers 4–7. It tests worksheet parity, not whether a heading is populated.

If a layout needs alternating positions relative to its first field, use the relative counter instead of raw worksheet column parity. Starting the table one column farther right should not accidentally invert a business-specific grouping rule.

In a current Microsoft 365 dynamic-array worksheet, enter this in B8 with B8:D8 empty:

=COLUMN(D1:F1)

Expected horizontal output: 4, 5, 6. The results are source coordinates, so moving the output anchor to B8 does not make them 2, 3 and 4.

The official reference distinguishes modern dynamic-array entry from legacy array entry with Ctrl+Shift+Enter. In a non-array legacy context, it describes the leftmost source column result, 4. Do not label every observed single-cell result as a function defect without checking the entry mode.

Suppose the four positions D2:G2 from the relative-counter example represent periods, and B12 contains a starting quantity of 100. This formula in D3 can be filled across:

=$B$12+10*(COLUMN(D1)-COLUMN($D$1))

Expected results are 100, 110, 120, 130. The first position adds zero; each step to the right adds ten. The omitted +1 is deliberate here because the first period uses the unchanged starting quantity.

This position-based model does not read the month text or handle unequal period lengths. State the assumptions before using a similar pattern for an operational forecast.

If a result is off by one, identify whether the calculation is zero-based or one-based. If filling across produces the same result everywhere, inspect absolute references. If a range returns one number rather than a row, inspect array-entry mode and the receiving Excel edition.

Use a single-cell reference when a single coordinate is required. To check the number of fields in D1:F1, the dimension is three, not COLUMN’s coordinate four or its coordinate array 4,5,6.

• MOD in Excel
• SEQUENCE in Excel
• INDEX in Excel

Verification: These are fictional inputs and independently calculated expected results, not native Excel observations. See the editorial testing standards.