Converting results into Percentages

[collingrey]

Hi all

If I have a 4 x 4 table, (these are the results from previou
calculations), I need to find out if there is anyway to determine ho
many cells are the same, and convert this into a percentage of th
total number of cells, meaning that if A1, A2, A3 & A4 are the same
say Pete, and B1 and B2 are Mary then the results wolud be :

25.0% Pete
12.5 % Mary
etc.


Thanks in advance
Colli

 

[Frank Kabel]

Hi
if your data is stored in A14 and you enter the possible
values (e.g. Pete, Mary, etc.) in E1:E10 enter the
following formula in F1:
=COUNTIF($A$1:$D$4,E1)/16
and format this cell as percentage. Now copy this formula
down

 

[collingrey]

Thanks it works great

Colli