How can I substitute my FILTER() formula for prior versions of Excel?

I created this FILTER() formula which works perfectly, however, turns out I need a formula that accomplishes the same thing, but in Excel versions prior to 365.

=FILTER('Employees List'!A2:A42,('Employees List'!B2:B42<>"Off Shift")*('Employees List'!C2:C42<>"No"),"No Employees On Shift")  

Basically, what the formula does is: If column B does not equal Off Shift, and Column C does not contain "No", then return the value in column A.

I did not know how to do this any other way, which is why I created the FILTER() formula. I have currently 42 names in column A, and I didn't know how to return these values while also not pulling duplicates

Would greatly appreciate any help. Please let me know if I need to provide further clarification

https://stackoverflow.com/questions/66020149/how-can-i-substitute-my-filter-formula-for-prior-versions-of-excel February 03, 2021 at 09:49AM