DATE FROM ONE COLUMN BASED ON CRITERIS FROM A DIFFERENT COLUMN

Question

Hello Everyone,

Thank you in advance for all the help !!! Hopefully I can explain it well enough.

I would like to obtain data from one column based on another column. For example:

Column B has the team's jersey color

Column C has the teams' pants color

In one cell I would like to know how many of the teams with green jerseys also have black pants

Then in another how many teams with green jerseys also have yellow pants

I hope that explanation is not too simple

Thank you !!!

D WOLLAM

Answer 1

Yes, you are absolutely correct. I was trying to get an example to be as simple as possible, without explaining sports gambling. I think I added the link correctly.

https://www.dropbox.com/scl/fi/yu610bq6ub7r03ejlm38d/DROPBOX-xls.xlsx?rlkey=o2n1etuxrliw9sfey4kfw0v6l&st=8rafnxur&dl=0

Answer 2

I get the feeling that you are not really dealing with jerseys and pants. Can you save your file to Onedrive (or similar) and share a link here so that we can have a look at it?

Answer 3

Hello Again Riny,

So I gave it another shot and was successful in adding the additional columns for the the other colors: black, green, etc. However, is there a way to add a column that would display the percentage for each? in the example above, in cell J$ I would like to put a formula that would show the percentage of green jersey/black pants. When I inserted a simple formula referencing the appropriate cells in the Pivot Table it returned 0.

Thanks again for all of your help!!

D WOLLAM

Answer 4

Hello Riny,

I have considered a Pivot Table but I am very new to using them. I will try again now that I see you can have more than one column for the different colors.

Thank you

Answer 5

Have you considered a pivot table?

Picture taken on a Mac but it works the same and looks quite similar on a PC.