In column one I have the names of many companies. Each company has different
sales amounts. so each company is listed more than once (each company may be
listed a different amount of times, depending on the number of sales) I have
sales subtotaled for each company. In the next column over I would like to
calculate the percentage of a value compared to the subtotal. i need to do
this for each group. I could do this if there were the same number of sales
for each company, but how do I create a formula to do this when there are
different numbers of values?