+ Reply to Thread
Results 1 to 2 of 2

Conditional filter for a movie/series database

  1. #1
    Registered User
    Join Date
    02-06-2020
    Location
    US
    MS-Off Ver
    2019
    Posts
    1

    Conditional filter for a movie/series database

    Hi everyone,

    I want to create a database for my movies and series with the following columns:
    - Title
    - Year
    - Genre (comedy, romance, etc)
    - Type (movie, tv series)
    - IMDb score
    - Running time (hours)

    Of course this is basic.

    So here's my question:

    How can I create a sort of generator for these movies/series? For example, I want to filter all 2017 comedy movies, with 7 and up IMDb score, with a running time of 1:30hour or less. Is it possible in excel? I know I can do it on a website but I want to do it on excel so I can access it anytime I want.

    Thank you in advance!

  2. #2
    Forum Guru Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    Excel 2010 on Linux
    Posts
    10,965

    Re: Conditional filter for a movie/series database

    Administrative note

    Welcome to the forum

    missed the yellow banner advising how to get answers faster by posting a sheet ?

    Please take a moment to read it and attach a sheet accordingly.

    Thanks you for helping us help you

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with Movie Database Excel Sheet
    By mn072065 in forum Excel General
    Replies: 3
    Last Post: 01-14-2018, 10:22 PM
  2. [SOLVED] Movie Database Search.
    By hecgroups in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 03-09-2012, 04:43 AM
  3. movie database
    By vampyr07au in forum Access Tables & Databases
    Replies: 19
    Last Post: 05-01-2011, 06:46 PM
  4. movie database
    By Robert Holloway in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 01-02-2011, 02:09 PM
  5. Movie Database macro
    By Endlin3 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 02-16-2010, 06:07 PM
  6. Time Series Graph to Movie Clip
    By dudekid in forum Excel General
    Replies: 1
    Last Post: 10-06-2009, 05:46 AM
  7. Movie Database Lookup
    By macky1730 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 08-19-2009, 01:23 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1