title: Excel Duplicates increment by 1
body: <p>I am trying to write a formula so when a name is listed a number of times in column C the first column (A) adds by 1 (see below the QCD,QCD2..). I also need to include a condition where the attendance must match before counting up. For example below the column with O2 would not be QCD3 it would be the first instance of QCDOT.</p>
  <p><a href="https://i.stack.imgur.com/Ep86b.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/Ep86b.png" alt="enter image description here" /></a></p>