What is displayed in a table?

C

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
 
Top