title: Is there a formula that takes the adjacent cell to the top 10 values and deals with identical values?
body: <p>In order to better analyse pages over time for <strong>SEO optimisations</strong> and rankings, I've made an excel spreadsheet that pulls in the top 20 pages by impressions and compares it to the top 20 pages by clicks. </p>
  
  <p>I download the report for pages from <strong>Google Search Console</strong> and copy it into a sheet called <strong>PageDataInput</strong>. In a sheet called <strong>Page</strong> it pulls the top 20 pages according to the key metric chosen, either impressions or clicks</p>
  
  <p>The table for impressions works without issue because there aren't any duplicate impressions and there is a low likelihood that there will be. However, this isn't the same with clicks.</p>
  
  <p>Instead of referencing the next page with the same value, it just references the same page with that click for as long as there are duplicate values. Meaning that if there are 5 pages with the same click value, it'll reference the first page 5 times and then move on to the next page. </p>
  
  <p>For Impressions I've used:</p>
  
  <pre><code>=INDEX(PageDataInput!$B$2:$B$952,MATCH(1,INDEX((PageDataInput!$D$2:$D$952=LARGE(PageDataInput!$D$2:$D$952,ROWS(B$2:B2)))*(COUNTIFS(B$2:B2,PageDataInput!$D$2:$D$952)=0),),0))
  </code></pre>
  
  <p>For Clicks I used the same code just different column to check:</p>
  
  <pre><code>=INDEX(PageDataInput!$B$2:$B$952,MATCH(1,INDEX((PageDataInput!$C$2:$C$952=LARGE(PageDataInput!$C$2:$C$952,ROWS(I$2:I2)))*(COUNTIFS(I$2:I2,PageDataInput!$C$2:$C$952)=0),),0))
  </code></pre>
  
  <p>The columns are all set correctly.</p>