Filter and Drop Down

Copper 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