Tuesday, April 30, 2019

Create a Dynamic Named Range

Do you have a table that has data added/removed on a recurring basis and it's an input to other tables? When you add or remove records, you may have needed to change the references from the other tables. You can offset these work by creating a dynamic named range or an Excel table. Since I used the word "offset" in an earlier sentence it's a clue to the type of function that will be introduced. One way to create a dynamic named ranges is to use the OFFSET and COUNTA functions. It's a bit more involved in trying to understand what the combination of these two functions do, but if you're counting on learning some cool tips, check it out.

No comments:

Post a Comment