In Excel - I want to filter busineses by city...i.e.choose city by dropdown and see bizes in that city only...

Answer 1

This might work for you:

http://www.contextures.com/xlDataVal02.html

Answer 2

Make sure you have a header row - for example...City, Business Name.
Make sure the data begins on the row directly under the headers
Click Data/filter/Autofilter
Now you will see the dropdowns on the header row
Click the item you want to filter on, select the city and you'll see the returned rows

Answer 3

Autofilters are good if you need to see the information in a glance or if they are used in a back process (Macros)

But if your intention is to present the information to somebody else; say your boss, client, teacher, supplier... i would suggest to use a pivot table... It helps to have the information summarized and arranged base in <>s criterias.... pivot table includes the functionality of dropdown filter

If you need further help, i'll be more than glad to help you, just send me an email... [e-mail]

Answer 4

You could do it in VBA. Just create a query what looks up the biz according to the city you select.
But i think you anyway need to load it in a database.
After you have created a table, then you just say in VBA
"Select * from

Answer 5

If I remember this right, you have to highlight that column, go up to tools, and select autofilter