title: Excel Sequence number based on cell value
body: <p>In excel, how can I create auto numbering in column A ? eg. If I key in cell value in D1 with "BILLY", column A will populate sequence numbers from 1,2,3.....</p>
  
  <p>I have googled and found the closet is using below formula but unable to accomplish what i want because in column C i have multiple data need to select.</p>
  
  <p><a href="https://superuser.com/questions/645859/auto-sequential-numbering-based-on-cell-criteria/645903">https://superuser.com/questions/645859/auto-sequential-numbering-based-on-cell-criteria/645903</a></p>
  
  <pre><code>A     B     C
       ABC    JAMES
       XYZ    BOB
  1    OXY    BILLY
  2    BNX    BILLY
       SDA    MIKE
  3    WXK    BILLY
       SAK    JANE
  </code></pre>
  
  <p>Anyone have done this before with formula or vba? would appreciate your help, thanks.</p>