To know the number of the first column in the range, all you have to do is follow the MIN Function with the combination of COLUMN Function. 

Previously:- How to Count visible rows in a filtered list using SUBTOTAL formula?

To elaborate the same, let’s take an example:

number of the first column

As you can see, we have a bunch of data which is based on a particular product or item. 

To get to know the first column in the range through a formula, let’s input the formula in the sheet.

number of the first column

The formula for the same is =MIN( 

The following formula requires number 1, number 2, etc. but this formula as a whole does not fulfil our need and so we insert another formula in the same. 

number of the first column

So, the same becomes =MIN(COLUMN(

number of the first column

The column formula requires a reference, so we will select the table or in other words our whole data, then we will close the bracket and press enter.

number of the first column

And BAAAMMM! The answer is 2, i.e. the first column in the range has started from 2nd or in other words B.

If you move your data to any other position, the formula will show the true place of the first column in the range.

number of the first column

It’s easy, isn’t it?