Complex (for me) coding issue.

[AlexanderBB]

I'm comparing a backup table in Access with popup comments in an Excel Worksheet.
First I get all the Excel comments and see if they exist in Access.
If they Exist, are they the same in Access.

Then I do the same in Access. Although they're stored differently. Columns J & O are in their own field but anything else
is in the one field, delimited by "~". Each starts with its Excel Column then the actual comment follow inside in square brackets.

If anything differs I write the details to a Listview control.

So I'm nearly there, but getting duplicate entries where they exist but are different. And having trouble sorting why.
I've tried flowcharting it but am missing something. It'somethig to do with knowing the comparison is alraedy done.
I could show my code but it's a but insane. Is the problem apparent to anyone else? Maybe there's some better logic I should be following?

Thanks for any suggestions.

 

[offthelip]

If you are doing your comparison in arrays ( which you should be for speed) rather than on the worksheet, you could delete both entries once a match has been found.