Forum Discussion
Data Validation cascading
The attached might work in Excel 2016, but I have no way of finding out. Working without FILTER and UNIQUE is somewhat like trying to use a lawnmower to trim a hedge; simply the wrong tool for the job!
p.s. I have only just looked at the file you attached showing your Excel version. If it is Office 365 monthly then it is very odd that the original files do not work for you.
i really apologize guys.
It still gives me an error.
This my excel version (image attached)
fname
=_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER(Employee[Fname], Employee[Lname]=LName.selected, Employee[Fname])))
lname
=_xlfn._xlws.SORT(_xlfn.UNIQUE(_xlfn._xlws.FILTER(Employee[Lname], Employee[Fname]=FName.selected, Employee[Lname])))
select fname
=_xlfn.ANCHORARRAY($H$3)
select lnname
=_xlfn.ANCHORARRAY($D$2)
The attached might work in Excel 2016, but I have no way of finding out. Working without FILTER and UNIQUE is somewhat like trying to use a lawnmower to trim a hedge; simply the wrong tool for the job!
p.s. I have only just looked at the file you attached showing your Excel version. If it is Office 365 monthly then it is very odd that the original files do not work for you.
I agree withPeterBartholomew1 : If you have Office 365 Pro Plus (or whatever it was; that was the idea) it doesn't make full sense. You should check and see if you can get the latest Dynamic-Array-Ready version.
Unless you're in a government office where it takes a while; I did exchange a similar suggestion with someone last month. She had the latest on her Microsoft Surface pad and could see how the ARRAY functions worked, but the government supplied work computer wasn't able to run them and the IT department would take a while to get to it.
Those tools are quite astounding. This YouTube video is a great intro if you have any doubts.
https://www.youtube.com/watch?v=9I9DtFOVPIg
