How to create a dynamic named range with a Table

This is the simplest way to create a dynamic named range in Excel.

This table contains data for ten properties.

I can easily create a named range for this data.

For example, I can create a range called “data.”

Then, using theROWS function, I can get a total count of properties.

The problem is that this range is not dynamic.

The solution is to create a dynamic named range that expands and contracts as data is added or removed.

The easiest way to create a named range in Excel is to use the Table feature.

In most cases, the answer will be “yes.”

When you click OK, Excel will create the table, apply formatting, and add autofilter controls.

Excel will automatically give the table a name, but you could change this name if you like.

The new table range will appear in the name box, and in the Name Manager.

Note that when I snag the data, Excel automatically uses the table name.

The same is true if I useCOUNTIFto count sold properties.

Like the table itself, these references are dynamic.

There are several other ways to create dynamic ranges in Excel that we’ll look at in other videos.

However, a table is a great starting point if it’s a good fit for your situation.