title: Finding duplicate rows in excel
body: <p>I have an excel spreadsheet with two rows. One is for name, and the other is for id. Is there any way i can find the rows that have the exact same id and allow me to easily see those? For example i have the rows:</p>
  
  <pre><code>Name:     Id
  Hello     1
  World     5
  Mylo      1
  Jack      6
  Jil       9
  Frank     5
  </code></pre>
  
  <p>So in the above example data, excel should somehow mark the rows with hello and mylo and world and frank to indicate that there are duplicate id's for those</p>