title: Formula to count each individual digit in a cell per column in Excel
body: <p>I have a list of numbers like below. And I need to know how many of each number are in each cell per column.</p>
  
  <pre><code>My List
  1
  2
  3
  4
  10
  11
  12
  13
  14
  21
  22
  23
  24
  </code></pre>
  
  <p>I need to know how many times 1 occurs throughout the whole list, including double digit numbers, and I need to do this for each number 0-9. The reason I don't just count them is because I have a total of 1,400 numbers that I need to break down. I have tried =COUNTIF but unfortunately it sees numbers such as 22 and ONE number, when I need it to tell me that there are 2, 2s. Is there a way? Thanks!</p>