Tidying up workbook (and pivot table help)...

[AlbertKJ]

Ok,

Hopefully this doesn't come across as lazy or anything like that! I hav
about 1500 lines on sheet 1 and roughly the same on sheet 2. Th
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'v
watched from a director and in the same pivot table showing how many o
his films are on my 'to watch' sheet - is this possible?

I know my 'to watch' list contains the films I've already watched, thi
is a bad habit of mine as I never delete them off that list for som
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

+-------------------------------------------------------------------
|Filename: Film list sample.zip
|Download: http://www.excelbanter.com/attachment.php?attachmentid=273
+-------------------------------------------------------------------

 

[Jim Cone]

Why not just sort the list(s) by director or use the auto filter to show a particular director.

You might want to download... "Greatest Film List.xls" at
http://www.mediafire.com/PrimitiveSoftware
An Excel list of over 9000 ranked films with director and date and one click sorting. (free)
--
Jim Cone
Portland, Oregon USA




"AlbertKJ"
<[email protected]>
wrote in message
news:[email protected]...