I have a list of persons each related to one single department. What I want is a named range referring to all persons inside a given department. There are just 3 departments
The naming function should be something like this (obviously not working):
- The range should update dynamically after deleting/adding persons
- If it can be done via a function like the above, that would be perfect.
Help, please? :-)
MS Excel 2007 NamingBasedOnCriteria.xlsx