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

  • Thread starter Thread starter John IV
  • Start date Start date
J

John IV

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 -
 
John

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

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 
Back
Top