What is displayed in a table?

[collingrey]

I am trying to determine, if say you have a table, with

A1 = Cherry
A2 = Bannana
A3 = Peach
A4 = Mango
A5 = Mango
A6 = Bannana
A7= Mango
A8 = Litchi
A9 = Cherry
A10= Litchi
A11 = Peach
A12 = Cherry
A13 = Cherry
A14 = Cherry
A15 = Mango
A16 = Peach

I need to determine all of the types of fruit in the table, bearing i
mind that it is variable and the next time there may be Pears, Plum
etc, so I need to know exactly what is presently in the table and ho
many times it occurs, this part I can do with countif, so I only nee
to know what is in the table. eg
Results:

31.25 % Cherry
18.75 % Peach
25.0 % Mango
12.5 % Litchi
12.5 % Bannana


Colli

 

[Frank Kabel]

Hi
use a pivot table for this. See:
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm