Good day!
I made a registration sheet where a user enters either the name or employee number and upon hitting search, reveals the results.
=FILTER(Raw!B2:F39873,ISNUMBER(SEARCH(E6,Last_Name))+ISNUMBER(SEARCH(E6,First_Name)),"No records found")
B2:F39873 is the range that contains the Organization, Employee ID, Last Name, First Name, and Site.
Last_Name is the name of the range which holds the last names (D2:D39873)
First_Name is the name of the range which holds the first names (E2:E39873)
EID is the name of the range which holds the employee numbers (C2:C39873)
The problem is, when the file was sent to the team managing registration, the team had a non-Office 365 account, hence did not recognize the FILTER function.
How can I replace this formula for use by a non-Office 365 user?
Bookmarks