Hi

I am using Excel to create a database for my extensive VHS collection.

Currently i have the following headlines for the movies: Number,
Title, Subtitles, Genre, IMDB Score, My own score.
Like this:

Nr. Titel Subtitles Genre IMDB My own score




3 Once upon a time in America DK Drama 8,3 8
4 Scary Movie 2 DK Comedy 5,1 5
5 Last Boyscout DK Drama 7,9 8
Etc.
Now i can use the autofilter on all of the categories, but what if i
want to add more genres to each movie? I need to be able to filter on
it. I tried adding multiple genres seperated by ; but it didn't work.
If I filtered on drama and the coloum said Drama; Action i didn't show
up when i filtered on either of them. Anyone got an idea of what i can
do?