julie - Feb 8, 2016 at 01:10 AM
I have 3 columns Male, Female AND Long Sleeve, I then have 7 columns of sizes 4XL, 3XL, 2XL, XL, L, M, S. If and x is placed in one of the 3 columns for TYPE {say Male} and on the same row an x is placed in the size (SAY S) and I have 330 rows, what would be the formula so that I can get a value of TYPE and SIZE on all 330 rows with the SIZE compared to the TYPE????