title: How to get unique values in a column using excel formula
body: <p>I have Excel Data like below</p>
  
  <pre><code>       JID     Val
  
         1001    22
         1030    6
         1031    14          
         1041    8
         1001    3
         2344    8
         1030    8
         2344    6
         1041    8
  </code></pre>
  
  <p>How do i get the unique JID values like below using formula?</p>
  
  <pre><code>UJID   
  
  1001
  1030
  1031
  1041    
  2344
  </code></pre>