Create a reference list to autofill

%3CLINGO-SUB%20id%3D%22lingo-sub-2612982%22%20slang%3D%22en-US%22%3ECreate%20a%20reference%20list%20to%20autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2612982%22%20slang%3D%22en-US%22%3E%3CP%3EOffice%20365%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGood%20evening%2C%3C%2FP%3E%3CP%3EI%20work%20in%20a%20university%20and%20I%20work%20with%20data%20query%20dumped%20into%20Excel.%26nbsp%3B%20The%20department%20has%2025%20full%20time%20faculty%20names%20(never%20changes)%20and%20up%20to%2050%20adjunct%20faculty.%3C%2FP%3E%3CP%3ESome%20faculty%20teach%20up%20to%208%20sections%20of%20a%20course%2C%20so%20I%20frequently%20deal%20with%20300%20rows%20of%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ERight%20now%2C%20I%20have%20to%20insert%20an%20additional%20column%20and%20manually%20identify%20each%20faculty%20member%20as%20FT%2C%20ADJ%20or%20UNA%20(if%20a%20course%20has%20yet%20to%20be%20assigned%20to%20an%20instructor).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20build%20a%20custom%20sort%20based%20on%20the%20info%3F%3C%2FP%3E%3CP%3EThank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2612982%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2615575%22%20slang%3D%22en-US%22%3ERe%3A%20Create%20a%20reference%20list%20to%20autofill%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2615575%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1120793%22%20target%3D%22_blank%22%3E%40CoachSandy%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EPerhaps%20you%20could%20create%20a%20second%20query%20that%20contains%20the%20professors'%20names%20along%20with%20their%20status%20(FT%2C%20ADJ%2C%20UNA).%26nbsp%3B%20Then%2C%20merge%20the%20first%20query%20with%20the%20second%20query%20and%20filter%20out%20the%20professors'%20names%20from%20the%20second%20query.%26nbsp%3B%20Take%20for%20example%20the%20following%20blog%20post%3A%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fwww.myonlinetraininghub.com%2Fexcel-power-query-vlookup%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fwww.myonlinetraininghub.com%2Fexcel-power-query-vlookup%3C%2FA%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

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 faculty teach up to 8 sections of a course, so I frequently deal with 300 rows of data.

 

Right now, I have to insert an additional column and manually identify each faculty member as FT, ADJ or UNA (if a course has yet to be assigned to an instructor).

 

Is there a way to build a custom sort based on the info?

Thank you.

1 Reply

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