I have a spread sheet with table data which is formatted like this:

ID 1 | ID 2 | Name | Date | Address | (etc.)

ID 1 and ID 2 is supposed to be a composite key and should not repeat. How should I go about **finding** duplicate composite keys in the **entire** sheet? Some of the answers presented here either 1) simply don't work or 2) only compares with the next row.

Note: I would prefer not to use VBA, as VBA takes a while to code (as opposed to formulas, that is)

Note 2: I am using Excel 2010