I have a Named Range named Car. In another tab, I have:
A16 reproduces the header of the Named Range:
A17 lists out the values in the Named Range:
If I ever change the name of the Named Range, I'd like to avoid having to manually update the formula in A17. That way, I only have to update the Range name and the header in the other tab (Categories!C1).
Is there a way to use the FILTER formula, but instead of referencing the Named Range, I pull from the value in A16? Something like:
=FILTER(Range matching A16,NOT(ISBLANK(Range matching A16)))
I know that's not right, but I'm not sure if there is in fact a feature to pull this off. Any insight would be much appreciated!