Home > Software engineering >  Filter with VBA in excel
Filter with VBA in excel

Time:11-06

I am trying to filter my movie list. Unfortunately it doesn't work out so well yet. I found a very fast way, but this one is missing a few options. If I read the entire column into an array and search for the individual words, it takes a relatively long time for over 2000 movies. What I miss: In column A I can only filter by the first word. So it only goes from the beginning of the title. For example, "F" finds all "Film*" titles.

In column B and C I would like to be able to sort "from to". So all movies after 2012 and for example all with a rating better than 7.

In column G and H I have again the problem that I can only sort from the front. So if the genre Action is in second place, I can't find it. Additional i want to find 2 genres for example:"* Crime * Action*"

What works well is that I can now already combine.

enter image description here

The Excel Sheet:

enter image description here

Sorry for the german screenshot.

  • Related