How would you do this. I have a column, C, that has a bunch of names in it say Apple, Orange, Bananna. I want to write a formula that tells me for all the Apples in column C what percent of "yes" answers do I have to a yes/no question in column E. I am using y and n in column E. Do I need to use Vlookups? How would I do that?