Forum Discussion
Create a reference list to autofill
Office 365 Good evening, I work in a university and I work with data query dumped into Excel. The department has 25 full time faculty names (never changes) and up to 50 adjunct faculty. Some f...
Hello CoachSandy,
Perhaps you could create a second query that contains the professors' names along with their status (FT, ADJ, UNA). Then, merge the first query with the second query and filter out the professors' names from the second query. Take for example the following blog post:
https://www.myonlinetraininghub.com/excel-power-query-vlookup