Identifying Unique Rows
 

I'd like to find a nice clean way to identify rows, but am not havin
much luck.

I currently have a file that I update from an external source.
This is a record of aircraft logs and each row is a log entr
containing eight cells, which are text, except for one date column.
the external source does not assign a primary key cell, and the orde
the rows are delivered is not consistant.

I currently have it set up to copy old data from the primary sheet to
temp, update the primary sheet, check the primary for rows that don'
exactly match those in the temp sheet, and copy those rows to a "Ne
Entries" sheet.

my method of the comparison is both unstable and brute force. i
generates a "checksum" based, mostly, on the number of text in eac
cell, sorts both sheets by checksum, looks for and deletes matches, an
finally copies the result to the differences sheet.

I'm hoping someone has an elegant way of comparing rows, because my wa
is ugly and time consuming.

Thanks,
Kestre

--
Kestrel149

-----------------------------------------------------------------------
Kestrel1492's Profile: http://www.excelforum.com/member.php...fo&userid=2484
View this thread: http://www.excelforum.com/showthread.php?threadid=38564