Here we have a set of sales data that spans 2 years, broken down by month.
Generally, the fastest way to create a named range is to use the name box.
Just make a selection and punch in a valid name.
To see a list of existing names, use Control + F3.
On a Mac, add the function key.
Names also appear in the name box drop down.
In this case, the names come from the Top Row.
Now we have 6 names.
As you enter formulas names will match automatically as you pop in.
Confirm a name with Tab.
In Windows, you’ve got the option to also paste a name into a formula using F3.
it’s possible for you to also just point and click, which works on both platforms.
Array formulas must be entered with Control + Shift + Enter.
Now when I change the name, the summary is fully dynamic.
First, I’ll get a full set of names from the table, paste, and remove duplicates.
With the Ribbon, data validation is:
Alt A, then VV.
For the List, I’ll paste in “Names”.
Now we have a working drop down.
