title: Excel: Count the number of occurrences
body: <p>I have data in the following format </p>
  
  <p><img src="https://i.stack.imgur.com/NOFa7.jpg" alt="data"></p>
  
  <p>(about 2000 lines)</p>
  
  <p>What is an efficient way to count the number of wins and loses for each coefficient? </p>
  
  <p>I have tried to split each coefficient into separate column and then sort my wins and loses, but this is very time consuming. </p>
  
  <p>I want to get this table:</p>
  
  <p><img src="https://i.stack.imgur.com/DGKEp.jpg" alt="table2"></p>
  
  <p>Thank you</p>