Excel COLUMNS function

The ‘COLUMNS’ function in Excel will return the number of columns between a specified cell range.  For example, there are three columns between columns B and D (B, C, D) and thus =COLUMNS(B4:D4) would return an output of 3.

The COLUMNS function can be particularly useful when using functions which require a column argument (e.g. VLOOKUP) on large sets of data where it is not easy to manually count the number of columns in an array.

To identify the specific column number of an individual cell, the COLUMN function is more appropriate to use.

Syntax

=COLUMNS(array)

Arguments

array – input cell range (i.e. the cell the range you wish to know how many columns there are in between)

Function category

Information

Returns

The COLUMNS function will return the number of columns between a specified cell range.

Download Excel File

 Example of COLUMNS formula

Comments (No)

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.