cross referencing by title and actor name?

A

Annabanana-1

I'm using Excel to list my film inventory. I would like to cross reference
it to actor's names, ie Airforce 1 x Harrison Ford Harrison Ford x Airforce
1.

Harrison Ford x Airforce 1.
 
L

Luke Moraga

Assuming a grid where actors are listed across top, and movie titles in
column A, you could then place an "x" at each intersection between the
columns and and approriate row. This would allow for multiple actors per
movie, and vice versa. You could then do a data-filter-autofilter.

Then, you can either pick a movie title from column A and see all the
actors, or go to an actor column, choose to see all the "x" and then you can
see all the movie that actor is in.

Is this what you were looking for?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

automatially add periods between a character name and the actor 4
Access Query Help - Select from 2 tables 2
Macro question: Using named ranges 6
Rearranging Name Format 7
Consistent Sheet column header rows 2
Section and Page numbering 0
report problem 3
Cross-reference Insert Default Change 0

Top