Would this work to organize movies/TV series in Excel?

I would like to keep a record and organize my movies and TV series in Excel. I bought the Office 365 Personal month to month and I would like to use Excel for this. I also would like to have my TV shows separate than movies.

So, may I please ask if the following way would or would not work?


Title
Series
Category (Movie/TV/documentary/etc)
Date of Original Release
Date of DVD Release

And than write all the movies and TV series and than data-sort and ONLY sort by category

And when doing TV series and under title, it would be the name of the show 1-1, 1-2, etc, episode name. 1-1 means season 1 episode 1, and than enter the episode name.

Would this be the correct way to do it?

The correct way would be with Access rather than Excel. Your proposed solution would work though

Access is rather too complicated for me and too complex. I asked for help on the Access forums and I did receive responses and it went over my head.

If you have a fish about on the forum, I remember helping some bloke with something similar that also automatically imported plot summaries and ratings from online movie/tv databases - might be worth a look if you can find it

Thank you! But I currently do not have them in a database. Do you mean write them in Excel and than import them to Access? Could you please provide that link to me?

No, I don't. I mean once you've typed them in to Excel it imports the plot synopsis etc.. (forget about the access bit if you're not interested, you have to put some real time into learning relational databases or you end up making a mess - Excel is easy)

OK, I'll forget about Access. So, just do it like in my opening post?

Yup, just keep everything in a big table

Thank you!

Thank you so much!

And than just sort the C column only which is the Category column?

Do you mean select all data on column C?

I am not sure what you mean by click on Sort, Filter, Custom, and I also don't know what you mean or how to find out if I have headers? I thought to Sort I would click on Data than click on Sort?

Thank you! I'll follow the top part by clicking on it on my Home tab because I do not have a clue with the buttons in my Data tab.

All I need to do is click on Sort and Filter than click on Custom than click on Sort C column, right?

Thank you!

I had posted a thread on Access Forums for doing this by sorting movies/TV series in Access, and I had made that thread before making this thread for doing this with Excel.

I am interested in using Access to do this, but on Access forums they was responding in the most difficult and complex way that I did not have any clue at all what they was saying. He did link me to some tutorials but they are too complex for me to even understand.

Here is the thread (http://www.accessforums.net/access/h...tml#post230542)

My way did not work and all it did was made the list a mess and out of order when sorted the list.

Here is what I mean.

Episodes maybe 1-21, 1-22, episode name, etc from within a season might appear on the top of the list, and than we have other series of shows, and we have 1-1, episode name within that one series and that appears separate from the series it should be where its suppose to be but instead its listed some place else so yes, its a bigger mess.

You need to use a custom sort so you sort by series name then by episode number

Hi Kyle,

I do not have season # or episode # columns. Here are the columns I have along with one episode example how I am doing this.

Title
Series
Category
Date of Original Release
Date of DVD Release

Ok, now this is how I was doing it. Let's take season 1 episode 2 which is 46 Long from The Sopranos the HBO TV series.

Title:

The Sopranos 1-2, 46 Long

Series:

The Sopranos

Date of Original Release:

When first aired on HBO

Date of DVD Release:

When released on DVD for USA Region 1.

I apologize for asking but may someone please confirm what I am doing wrong in post #27? I would really appreciate it!

Thank you very very much!

http://en.wikipedia.org/wiki/List_of...ranos_episodes

So, use the episode name only in the Title column?

Originally Posted by newdoverman

This is how it would go with the data from the website:

Thank you! And that was for the TV series. How would a new spreadsheet would go for individual movies like A Bronx Tale, and movie series like James Bond, Harry Potter, etc? I am apologize for asking!

Thank you!

Do a custom sort and sort EPISODE TITLE than EPISODE than SEASON?

Thank you so much!

I don't think I am doing this right. Could someone please take a look at it?Movie List.xlsx

Could someone please take a look at this? In my opinion I don't think I am doing this right.

Originally Posted by php111

I don't think I am doing this right. Could someone please take a look at it?Attachment 327259

Thank you so much! Where did you get those numbers from for Column 1 and the release dates as well, and how do I know if I should enter the numbers into the columns or do not enter it?

I looked at the table again and I don't follow what you are saying, and with those numbers I have no clue what they represent so it would only make it hard for me to search because I honestly don't know what they mean.

By any chance is there an easier way to do with what I am asking in Excel because it is quite obvious that I do not even know how to convert to a table and I do not know how to even sort properly and you could clearly see in that post the one that was converted to a table for me and I tried to sort it and you could see it was out of order and with those numbers I do not know how to read them or even know what they mean?

Thank you so much for your help! How much would a tutor cost?