I have an Excel spreadsheet that lists duplicate records and I need to
compare one duplicate column to another column that may have duplicates.
Here is an example of my spreadsheet...

Date Log ID Log #
Technician's Last Name
1/20/2010 324048 20100115@107 SMITH
1/20/2010 324048 20100115@107 SMITH
1/20/2010 324048 20100115@107 LEWIS
1/20/2010 324048 20100115@107 ORANGE
1/20/2010 324048 20100115@107 BANANA

So, first you will notice that the Log ID is duplicated, then you see the
log # duplicated and then you have 4 different technician's working on that
log. So, the only records that I'd want after I do my formula or whatever I
have to do would be 1 record from smith, 1 from lewis, 1 from orange and 1
from banana. Basically, even though Smith is listed twice, I'd only like to
count it once. Can anyone help??


If you'll notice, the log id is the same for both technician's, but the
technician's name