Filtering Question

B

Brent

I have a list of 20 Names to filter in a list.

If I select one of the names, I would like the name to appear in a cell at
the top of the page.

Also, If I choose more than one name or all of the names, then I would like
to it equal the words "Master List"

Any ideas on how to do this. (Excel 2007)

Thanks,!
 
G

Gord Dibben

The first part can be achieved by Data>Filter>Autofilter.

Select a name from the list and the rest will be hidden.

The second part does not make sense to me.

What is the "it" that should equal "Master List"?

Please re-post.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

make cell equal a word if a data validation cell has a word in it 1
Filter a Drop List ? 1
separate names and designation from one cell into 2 colmun 5
How can I populate a drop down list from Data Validation? 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Search two columns in list for first and last name and return Id 4
Top X% in Pivot Tables 1
Filtering again 1

Top