Excel - Advanced Filter with Dropdown

A quick video on how to create a dropdown list for Advanced Filtering in Excel 2010

[jimaevich]

but when changing the drop down list it not filtering new one, that's the problem.

[kristinaelucas]

Love this - Microsoft doesn't explain this well, but you do!

[MacorettaBoozer]

it works, but the list one reupdate with a new selection from the drop down list. i have to refilter with the selection each time, is there a way for the data to be filter everytime a new selection is made in the list

[mlmontenegro]

how can i keep it in filter? i mean if i select another name from drop down, how will the filter change the output also? it worked only once. thanks!

[jackchavarria]

Roger you are so clutch. Thank you roger

[MacorettaBoozer]

great stuff roger! thanks again, really apprecite it

[jsserch]

Hi I'm trying to create a dropdown list diveded in categories. Is that possible?

[MrNcChannel]

i tried but cant. not sure what goes wrong..

[Stuntlyd]

But I want to keep a filter in the sheet