Filter and Drop Down

%3CLINGO-SUB%20id%3D%22lingo-sub-1582340%22%20slang%3D%22en-US%22%3EFilter%20and%20Drop%20Down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582340%22%20slang%3D%22en-US%22%3EI%20was%20told%20to%20make%20a%20list%20of%20people%20in%20the%20department%20with%20different%20job%20qualifications.%20Only%20problem%20is%20that%20when%20choosing%20filter%20only%20one%20column%20is%20showing%20up%20and%20not%20the%20other.%20For%20example%20if%20I%20am%20to%20select%20filter%20Kiln%20Tender%20only%20the%20one%20in%20column%20C%20shows%20up%20and%20not%20the%20ones%20in%20column%20D%2CE%2CF%2C%20etc%20I%20need%20it%20to%20be%20able%20to%20show%20all%20the%20possible%20ones%20not%20one%20column.%20Any%20way%20to%20get%20this%20done%20or%20any%20other%20way%20I%20can%20do%20it%3F%20Would%20be%20appreciated%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1582340%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582364%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20and%20Drop%20Down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582364%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F756241%22%20target%3D%22_blank%22%3E%40RajGrewal%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECan%20you%20check%20if%20this%20is%20what%20you%20are%20searching%20for%3F%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fdata-validation%2Fm-p%2F1570976%23M71032%22%20target%3D%22_blank%22%3Ehttps%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fexcel%2Fdata-validation%2Fm-p%2F1570976%23M71032%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1582408%22%20slang%3D%22en-US%22%3ERe%3A%20Filter%20and%20Drop%20Down%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1582408%22%20slang%3D%22en-US%22%3ENo%20I%20tried%2C%20thanks%20though%3C%2FLINGO-BODY%3E
Occasional Contributor
I was told to make a list of people in the department with different job qualifications. Only problem is that when choosing filter only one column is showing up and not the other. For example if I am to select filter Kiln Tender only the one in column C shows up and not the ones in column D,E,F, etc I need it to be able to show all the possible ones not one column. Any way to get this done or any other way I can do it? Would be appreciated
2 Replies

@RajGrewal 

 

Can you check if this is what you are searching for?

https://techcommunity.microsoft.com/t5/excel/data-validation/m-p/1570976#M71032

 

No I tried, thanks though