I have a named range where I want to pull employee names.
In the example, you will see it works in cell E3 but not in cell E10 when the criteria is a named range. Is there anyway to make it work with a named range?
I have a named range where I want to pull employee names.
In the example, you will see it works in cell E3 but not in cell E10 when the criteria is a named range. Is there anyway to make it work with a named range?
How about
=UNIQUE(FILTER(Employee,ISNUMBER(MATCH(Code,WestCoast,0))))
Also as you are using 365, I would suggest updating your profile.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks