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:

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.

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.

So, the same becomes =MIN(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.

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.

It’s easy, isn’t it?