title: How to count repeated values using VBA
body: <p>I am new to VBA and I am trying to find the number of times the same values are repeated in particular column.</p>
  
  <p>Then I need to paste the value and the count of the repeated value in column A and B of another sheet.</p>
  
  <p>I need to count the number of times repeated values:</p>
  
  <pre><code>PSV_Cust_1
  PSV_Cust_1
  PSV_Cust_1
  PSV_Cust_1
  PSV_Cust_1
  PSV_Cust_2
  PSV_Cust_2
  PSV_Cust_2
  PSV_Cust_2
  PSV_Cust_3
  PSV_Cust_3
  PSV_Cust_3
  PSV_Cust_3
  PSV_Cust_4
  PSV_Cust_4
  PSV_Cust_4
  PSV_Cust_5
  PSV_Cust_5
  PSV_Cust_5
  PSV_Cust_5
  PSV_Cust_5
  PSV_Cust_5
  PSV_Cust_5
  PSV_Cust_5
  </code></pre>
  
  <p>Result should be:</p>
  
  <pre><code>Value        Count
  PSV_Cust_1   5
  PSV_Cust_2   4
  PSV_Cust_3   4
  PSV_Cust_4   3
  PSV_Cust_5   7
  </code></pre>
  
  <p>Please any one help to get the outpu using VBA code.</p>