Complex Question about about sorting and filtering

[littletoyboat]

I have a very specific issue that I can't seem to find a solution to,
so I was hoping someone here will be able to help me out.

I work at an agency in LA, and I make phone calls all day. I have to
keep track of all the new TV and film productions that are coming out
of all the studios and networks. I was thinking I need a chart with
all kinds of variables: Title, Start Date, Studio/Network, type of show
(feature, pilot, series, etc.), categories for each crew position
(since we represent crew, we need to know which positions are filled
and which aren't), also notes on phone conversations as well as dates
for follow-up calls.

The big problem is this: Movies are frequently made by several
production companies, and each production company usually has several
films at once. So, I can't just have a column labeled "Prod Co,"
because Film A may be produced by Companies 1 & 2, while Film B may be
produced by Companies 2 & 3. If I'm calling Company 2, I need to know
I should ask about both films A & B.

I was thinking there should be a function where I can click on, say
"Company 2," and it would list all the movies it is producing, or click
on "Film A" and see all the companies making it. I think File Maker
has something similar, where you can make index card-type files that
cross reference information like that, but I dunno if you can do it in
Excel. Is there something I can do to work this out?

Thanks!

 

[J Laroche]

I have a very specific issue that I can't seem to find a solution to,
so I was hoping someone here will be able to help me out.

I work at an agency in LA, and I make phone calls all day. I have to
keep track of all the new TV and film productions that are coming out
of all the studios and networks. I was thinking I need a chart with
all kinds of variables: Title, Start Date, Studio/Network, type of show
(feature, pilot, series, etc.), categories for each crew position
(since we represent crew, we need to know which positions are filled
and which aren't), also notes on phone conversations as well as dates
for follow-up calls.

The big problem is this: Movies are frequently made by several
production companies, and each production company usually has several
films at once. So, I can't just have a column labeled "Prod Co,"
because Film A may be produced by Companies 1 & 2, while Film B may be
produced by Companies 2 & 3. If I'm calling Company 2, I need to know
I should ask about both films A & B.

I was thinking there should be a function where I can click on, say
"Company 2," and it would list all the movies it is producing, or click
on "Film A" and see all the companies making it. I think File Maker
has something similar, where you can make index card-type files that
cross reference information like that, but I dunno if you can do it in
Excel. Is there something I can do to work this out?

Thanks!

Have you enabled the Autofilter in Data / Filter ? At the top of each filled
column double arrows will appear. Click on them to filter your data (to hide
lines NOT matching the criteria). You can filter more than one column at a
time, for example to keep displayed only the lines containing both Film A
and Company 2.

JL
Mac OS X 10.3.9, Office v.X 10.1.6