FemBiochem
New Member
- Joined
- Jun 1, 2004
- Messages
- 3
Basic Excel Question here:
I want to create a list of peoples names and then filter it so that one persons name can be selected from that list. When I create the list and then autofilter I get a dropdown box showing my list of names and "all, top 10, custom". However, when I choose a name out of the list it does not get filtered out.
So, if my list were "Amy, Becky, Cathy, Dave" and I select "Dave" what iI see is that "Amy" is still at the top of the list and "Dave" appears below "Amy". How do I fix this?
[/list][/list]
I want to create a list of peoples names and then filter it so that one persons name can be selected from that list. When I create the list and then autofilter I get a dropdown box showing my list of names and "all, top 10, custom". However, when I choose a name out of the list it does not get filtered out.
So, if my list were "Amy, Becky, Cathy, Dave" and I select "Dave" what iI see is that "Amy" is still at the top of the list and "Dave" appears below "Amy". How do I fix this?
[/list][/list]