Get instant live expert help with Excel or Google Sheets
“My Excelchat expert helped me in less than 20 minutes, saving me what would have been 5 hours of work!”

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.

Find the First Column Number in a Range in Excel

Read time: 25 minutes

Figure 1. of First Column Number in a Range.

If we want to find the first column within a particular range, we are going to make use of a formula which is based on the Excel COLUMN Function.

Generic Formula

=MIN(COLUMN(rng))

Where rng is our specified range of cells within our worksheet.

How to use the Excel COLUMN Function.

When supplied with a cell reference, Excel COLUMN Function will return the column number of our reference. We are going to demonstrate the usage of the Excel COLUMN Function in the following three simple steps;

  1. Collect the data values available to us and arrange in separate columns in our worksheet.

In the example illustrated below, we will be working with sales entries/records for a store within the first six months of the year.

Figure 2. of Sales Records.

  1. We are now going to supply a cell reference for Excel to determine its column number. Hence, the following formula will be entered into the formula bar for cell E2 of our worksheet.

=MIN(COLUMN(A2:C7))

Figure 3. of the COLUMN Function in Excel.

The first column value for the example illustrated above is 1.

  1. We are now going to demonstrate what the column value will be when we begin entry of our data values in the next column. See example illustrated below;

Figure 4. of First Column Number in Range.

We can see that the First Column Number for Figure 4. above is now 2. Notice how our data values begin in the second column.

In the event that we require the first column number only, we can utilize the Excel MIN function for extracting only the first column number, which will be the least number value in our range.

Figure 5. of Final Result.

Instant Connection to an Expert through our Excelchat Service:

Our live Excelchat Service is here for you. We have Excel Experts available 24/7 to answer any Excel questions you may have. Guaranteed connection within 30 seconds and a customized solution for you within 20 minutes.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

Leave a Comment

avatar

Subscribe to Excelchat.co

Get updates on helpful Excel topics

Subscribe to Excelchat.co

Did this post not answer your question?
Get a solution from connecting with the expert

Another blog reader asked this question today on Excelchat:

Post your problem and you'll get expert help in seconds

Your message must be at least 40 characters
Our professional experts are available now. Your privacy is guaranteed.
Trusted by people who work at
Amazon.com, Inc
Facebook, Inc
Accenture PLC
Siemens AG
Macy's
The Allstate Corporation
United Parcel Service
Dell Inc