Simple Excel – Usage of column names for formulas

In the current article, I show why it is convenient to use the Format as Table option in Excel. Pretty much, it enables a new feature – you may refer to the cells in it not by an address, but with the column names above.

At first I tought it was some kind of cheating, and then I saw it is really cool. It looks like this:

Step 1 – Create the table

TableBonus

 

Step 2 – Refer to the columns

TableBonus2

 

I think this is quite beautiful and much more understandable for big formulas. You simply see what is behind the numbers.

Enjoy it! 🙂

About

VBA Developer

Tagged with: ,