How to make percentage by year from Excel?

Question

excel

Hello.
There is an array:
1932
1933
1935
1936
1938
1940
1940
...
About 2000 lines. I want to automatically build a chart or table in Excel, with a percentage of how much% each year takes in the total mass.
Who will suggest a solution?

Answer 1

There was such a question. Various solutions have been proposed:

• For Excel < 2013: Counting Unique Values ​​Using the COUNTIF Function
  
• For Excel >= 2013: In a summary report, you can use the Distinct Count function , that is, counting the unique values ​​of a field. There are also tutorials with pictures .
  

Answer 2

Extend this formula in the second column. The cell format is percentage.
$A$1:$A$8 - range of cells (does not change)
A1 - what to look for (how many times each cell is in the range)
8 - total number of cells