Calculating percentages for discrete values entered in an Excel column
15:23 05 Mar 2026

I have and Excel sheet column that looks as

     Value
     -----
       A
       A
       A
       B
       B
       C
       C
       C
       C
       E  

For each value existing in this column I need to calculate its percentage of occurrences in this column. The calculated values must be inserted on the top of each column.

Thanks in advance

excel