Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / June 2006

Tip: Looking for answers? Try searching our database.

[Q] Auto filter possible on multi-value cell?

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
John IV - 20 Jun 2006 07:31 GMT
I have a Music spreadsheet.

Column A - artist, B - Genre, C - Music style

1. I would like to somehow have multiple values in column C.
2. Additionally if I autofilter I'd like the autofilter to be able to filter
on each of the items in C.

So something like:

A         B               C
Enya    New Age    Celtic;World
ClannadNew Age    Celtic

Autofilter on Music Style shows dropdown for both Celtic and World
individually.  Choosing World would give Enya only, but choosing Celtic
would show Enya and Clannad.

Is this remotely possible? :-)  Thanks -
Nick Hodge - 20 Jun 2006 07:59 GMT
John

Use the custom option in the autofilter and in resulting dialog select
'begins with...', 'ends with...' or 'contains...'

Signature

HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

>I have a Music spreadsheet.
>
[quoted text clipped - 15 lines]
>
> Is this remotely possible? :-)  Thanks -
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.