Want to tidy up my workbook...

**AlbertKJ** · 01-05-2012, 04:38 PM

Ok,

Hopefully this doesn't come across as lazy or anything like that! I have about 1500 lines on sheet 1 and roughly the same on sheet 2. The attachment just gives a small sample of these to give you guys an idea. I'm looking to make a pivot table that shows the number of films I've watched from a director and in the same pivot table showing how many of his films are on my 'to watch' sheet - is this possible?

I know my 'to watch' list contains the films I've already watched, this is a bad habit of mine as I never delete them off that list for some reason :/ Probably makes matters more complicated?

Also, I'm open to any suggestions you have to tidy up/improve my setup - and of any other pivot tables that might be handy!

Thanks!

**Paul** · 01-05-2012, 06:55 PM

Hi Albert,

Your post does not comply with Rule 8 of our Forum RULES. Cross-posting is when you post the same question in other forums on the web. You'll find people are disinclined to respond to cross-posts because they may be wasting their time solving a problem that has been solved elsewhere. We prefer that you not cross-post at all, but if you do (and it's unlikely to go unnoticed), you MUST provide a link (copy the url from the address bar in your browser)to the cross-post. Expect cross-posts without a link to be closed a message will be posted by the moderator explaining why. We are here to help so help us help you!

Read this to understand why we ask you to do this.

http://www.mrexcel.com/forum/showthread.php?t=603261