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 -