Need help returning the number of times 2 events occur simultaneously

Hey everyone,

So im trying to create a 2D Matrix to see how many times 2 unique events occur. For example, I need to create a table which illustrates the number of movies which have a genre of action AND adventure, action AND comedy, etc.

I tried getting some help in the functions forum, but was sent over here since they felt it would best be suited to use VBA.

Really would appreciate your help. Please see the attached workbook.

Bump. Really woudl appreciate some help with this guys...I've spent hours trying to fig this out using built in functions and unfortunately nothing seems to work.

thoughts anyone?

how would i do that? If i use auto filter, its on a column by column basis which would potentially eliminate rows which have the desired data value (the data value may be in another column).

Thanks for your help!

wouldn't it make more sense to use a macro which checks each row to see if "action" and "80's perms" exist, if so add 1 to the appropriate cell in the matrix. I guess I could use the filter method, however, its too manual...i need the solution to be scalable to support 1000s of movies, so Id like a more robust solution to populate the 2D matrix.

Thanks!

thanks shg...this result would return whether or not the category exists in a column; obviously i would need to add the remaining 30 categories . What i need though is to be able to fill out the cells in the 'matrix' worksheet... so i would effectively need to be able to run a macro which would fill in a particular cell with the count of movies which are "action" and 80's perms. So if i were to finish adding the additional countifs for the categories, i would populate a table of zeros and 1s. Then would it make sense to to essentially check if a value in B34 + D34 = 2 then add 1 to the count in the appropriate matrix cell?

Thanks for your help!