I have an excel with rows as area and skill levels.Columns contains names.
I need to get a particular area and different skill levels.
I can use auto filter to select the correct area. But then my columns are
not filtered and I get the entire list of names around 200 names. But I need
to display only skill level say 5. Can I use auto filter to filter out the
columns also simultaneously.