I have a list with different colors and in the list it calculates how much
each color represents of the total. I'd like to create another list below
this one that will pull in any category that represents 10% or greater of the
total. I've been trying to use
{=INDEX($G$3:$G$16,MAX(IF($I$3:$I$160.1,ROW($I$3: $I$16)-MIN(ROW($I$3:$I$16))+1)))},
but I need to adjust it so that it doesn't pull the same color more than
once. Any suggestions would be greatly appreciated.


Color Name Total Tools Percent to Total
Orange 4 2%
Purple 45 26%
Yellow 8 5%
Red 10 6%
Blue 9 5%
Green 10 6%
Brown 35 20%
Black 6 3%
White 16 9%
Grey 8 5%
Pink 5 3%
Tan 5 3%
Cream 6 3%
Gold 6 3%
Total 173 100%

Any color which represents 10% or greater to total.
Purple 26.0%
Brown 20.0%