DATE FROM ONE COLUMN BASED ON CRITERIS FROM A DIFFERENT COLUMN

Have you considered a pivot table?

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

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

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

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?

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.

Hi,

Not sure of what you are trying to do but right click on any number in the Pivot Table and under Show values as, select % of row/% of column.

Thank you all, I have figured it out. Not sure what I was typing but I must have entered the formula incorrectly where I wanted the percentages to be displayed.