Excel VBA Checking Duplicates and delete duplicates
Budget: $30 – $250 USD
Hello everyone,
Need two separate codes.
1) Code
Requirements: Find duplicated words 80% in sentences and indicate about sentences which is duplicates. The word in text sentences can be random structure. Example in Excel.
A1-A5 formula > Sentences
C11-C5 formula > Duplicate columns
D1-D5 formula > Duplicate qty of sentences
2) Code
Delete every second full sentences duplicate. Keep only one original sentence also Delete empty row without sentences.
Example " 3 duplicates : 1A + 3A + 5A . Delete 3A and 5A duplicates and duplicate empty rows with sentenses.. Keep 1A sentence.
Second Example > 2A +4A . Delete 4A. and keep 2A original.
In Attachment Codes which need to update.
Need two separate codes.
1) Code
Requirements: Find duplicated words 80% in sentences and indicate about sentences which is duplicates. The word in text sentences can be random structure. Example in Excel.
A1-A5 formula > Sentences
C11-C5 formula > Duplicate columns
D1-D5 formula > Duplicate qty of sentences
2) Code
Delete every second full sentences duplicate. Keep only one original sentence also Delete empty row without sentences.
Example " 3 duplicates : 1A + 3A + 5A . Delete 3A and 5A duplicates and duplicate empty rows with sentenses.. Keep 1A sentence.
Second Example > 2A +4A . Delete 4A. and keep 2A original.
In Attachment Codes which need to update.