Hello,
Trying to sort my data as follows:
Sorting is based on the Color, for this example White >75% first, when all White >75% are gone then sort for all Blue >75%, When all blue are gone sort for all Red >75%. If no Color is >75% then sort using the color that has the greater %.
In cell B211 I would like the Level and in cell C211 I would like the Portion.
Thank you!!
Trying to sort my data as follows:
Sorting is based on the Color, for this example White >75% first, when all White >75% are gone then sort for all Blue >75%, When all blue are gone sort for all Red >75%. If no Color is >75% then sort using the color that has the greater %.
In cell B211 I would like the Level and in cell C211 I would like the Portion.
Thank you!!
![72ar87.png](/board/proxy.php?image=http%3A%2F%2Fi67.tinypic.com%2F72ar87.png&hash=4742dd41c3631b6a7b6bf17f7923b5c7)