I assume that you have a list in a column of all the DVD's. Assume that
this is in Column A

Then in column B there needs to be the corresponding type of film that
you have.
Click at the top of Column B

Then use Data Filter Autofilter

This will list all the film categories that are below

Hope this is what you are looking for
Hywel
Manchester UK


--
Hywel
------------------------------------------------------------------------
Hywel's Profile: http://www.excelforum.com/member.php...o&userid=14824
View this thread: http://www.excelforum.com/showthread...hreadid=345851