title: Excel: Finding next equal match in column
body: <p>I've googled for a solution to my problem for days and I just can't seem to get my head around how to do this. </p>
  
  <p>I have 28 chickens and I track the eggs each one lays each month. My Excel sheet looks like this:</p>
  
  <p><a href="https://i.stack.imgur.com/QuzQW.png" rel="nofollow noreferrer">Current Egg-cel sheet</a></p>
  
  <p>Column C is populated by the formula:</p>
  
  <pre><code>=LARGE($A$2:$A$29,$B1)
  </code></pre>
  
  <p>I'm using column B to increment the LARGE function</p>
  
  <p>I want column D to populate with which chicken number laid the quantity in column C.</p>
  
  <p>Obviously INDEX MATCH or VLOOKUP returns the first match for all equal values. How do I find the the next match? i.e.</p>
  
  <p><a href="https://i.stack.imgur.com/k6TUu.png" rel="nofollow noreferrer">Egg-cell sheet 2</a></p>
  
  <p>I've seen similar questions and solutions but I for the life of me can not get it to work. </p>