Hi. I wanted to use the FILTER function, but by the look of it you need a O365 subscription. As I work for a big company i might have to jump though some hoops to get this sorted. However, my issue is - If I do get O365 subscription and create some Excel sheets using this - if i pass the sheets to someone without an O365 subscription will the formula just cease to work does anyone know?
Please correct me if I am wrong about the subscription. If I type =FILTER it does not work, so guessing there is some truth.
In the meantime, I could create a load of vlook ups - but any idea on how to create a drop down list that works like a filter (so people can search for a name). I have a spreadsheet with names down one column and then about 20 rows of data associated. I wanted to make a quick look up of only some rows (on another tab) if someone selected a name. There are lots of names so ideally not use the Data Validation method.
Thank you.
Please correct me if I am wrong about the subscription. If I type =FILTER it does not work, so guessing there is some truth.
In the meantime, I could create a load of vlook ups - but any idea on how to create a drop down list that works like a filter (so people can search for a name). I have a spreadsheet with names down one column and then about 20 rows of data associated. I wanted to make a quick look up of only some rows (on another tab) if someone selected a name. There are lots of names so ideally not use the Data Validation method.
Thank you.
