title: Finding duplicates on a composite key in Excel
body: <p>I have a spread sheet with table data which is formatted like this:</p>
  
  <p>ID 1 | ID 2 | Name | Date | Address | (etc.)</p>
  
  <p>ID 1 and ID 2 is supposed to be a composite key and should not repeat. How should I go about <strong>finding</strong> duplicate composite keys in the <strong>entire</strong> sheet? Some of the answers presented here either 1) simply don't work or 2) only compares with the next row.</p>
  
  <p>Note: I would prefer not to use VBA, as VBA takes a while to code (as opposed to formulas, that is)</p>
  
  <p>Note 2: I am using Excel 2010</p>