Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How To Create Pareto Chart in Excel
  • How to Create Gantt Chart in Excel
  • Conditional Formatting Rules in Excel
  • Conditional Formatting Data bars Examples in Excel
  • How to Create Area Chart in Excel

References

  • Count rows with at least n matching values
  • How to get last column number in range in Excel
  • How to use Excel INDIRECT Function
  • Vlookup Examples in Excel
  • To count total rows in a range in Excel

Data Validations

  • Excel Data validation must begin with
  • Excel Data validation only dates between
  • Excel Data validation exists in list
  • How To Create Drop-down List in Excel
  • Excel Data validation whole percentage only

How to get first column number in range in Excel

by

You can get the first column (i.e. the starting column number) in a range with a formula based on the COLUMN function.

Formula

=MIN(COLUMN(range))

Explanation

In the example shown, the formula in cell F5 is:

=MIN(COLUMN(data))

where data is a named range for B5:D10

How this formula works

When given a single cell reference, the COLUMN function returns the column number for that reference. However, when given a range that contains multiple columns, the COLUMN function will return an array that contains all column numbers for the range. In the example shown the array looks like this:

Worked Example:   How to calculate next scheduled event in Excel

{2,3,4}

If you want only the first column number, you can use the MIN function to extract just the first column number, which will be the lowest number in the array.

Worked Example:   How to create dynamic named range with INDEX in Excel

Simple version

Entered in a single cell, the COLUMN function will display only the first column number, even when it returns an array. This means, in practice, you can often just use the COLUMN function alone:

=COLUMN(range)

However, inside formulas more complex formulas, it’s sometimes necessary to make sure you are dealing with only one item, and not an array. In that case, you’ll want to use MIN to pull out just the first item.

Worked Example:   How to count total columns in range in Excel

 

Post navigation

Previous Post:

How to retrieve first match between two ranges in Excel

Next Post:

How to return TRUE when all cells in range are blank in Excel

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

Logical Functions

  • How to use Excel XOR Function
  • Nested IF function example in Excel
  • OR function Examples in Excel
  • Complete List of Excel Logical Functions, References and Examples
  • Invoice status with nested if in Excel

Date Time

  • Get project midpoint in Excel
  • Add workdays to date custom weekends in Excel
  • Check If Two Dates are same month in Excel
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Get month from date in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • How to randomly assign people to groups in Excel
  • Group times into 3 hour buckets in Excel
  • Group times into unequal buckets in Excel
  • Categorize text with keywords in Excel

General

  • How to get amount with percentage in Excel
  • List worksheet index numbers in Excel
  • Excel Operators
  • Cell References: Relative, Absolute and Mixed Referencing Examples
  • Spell Check in Excel
© 2023 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning