Develop Macro to Find Duplicates Which May or May Not Be Exact Matches
$30-250 USD
Anulowano
Opublikowano prawie 10 lat temu
$30-250 USD
Płatne przy odbiorze
Requirement:
Develop a macro or recommend a solution to find duplicates which may or may not be exact matches (here after referred to as "duplicates") and display duplicates in groups.
Characteristics of duplicates
1) Duplicates can appear in any column from column G to J on worksheet "Data" of the attached file.
2) Duplicates contain the same alpha numeric characters and at least one (1) common word in column G or column H
3) Duplicates contain the same alpha numeric characters but may be separated by space, dash, full stop, comma, brackets etc as shown in "Duplicate Group 1", "Duplicate Group 3" and "Duplicate Group 4" in the "Answer" worksheet of the attached file.
4) Duplicates contain the same alpha numeric characters but may begin or end with different alpha numeric characters as shown in "Duplicate Group 2" and "Duplicate Group 4".
5) Duplicates shall contain a minimum of four (4) same characters
Characteristics of non duplicates
1) Non duplicates have the same characteristics as a duplicate but do not have common word(s) in column G or column H on worksheet "Data" of the attached file.
Output
1) Duplicates are displayed in groups as shown on "Answer" worksheet of the attached file.
2) Duplicate alpha numeric characters are in bold and red.
3) Duplicates may have the same alpha numeric characters but are grouped based on common word(s) in column G or H. In worksheet "Answer", "Duplicate Group 3" and "Duplicate Group 6" have the same alpha numeric characters "4K55" as shown in bold and red but are grouped differently whereby "Duplicate Group 3" is for "Basket Strainer" and "Duplicate Group 6" for "Snubber"
4) Non duplicates are grouped in sequence of alpha numeric characters as shown in "Non duplicates" of worksheet "Answer"
Hi,
Let me introduce myself as an expert VBA programmer. I have used VBA extensively for Excel, MS Word etc..
I would be happy to answer any queries that you may have.
Thanks & Regards
FineCoder
Hi,
I am working as Lead Pricing Analyst in a Fortune 500 MNC. I have worked on pricing models, income statements, value-pricing projects etc. I have worked extensively on excel and VBA in my job and here on freelancer as well.
I believe I can help in your work. Please have a look at reviews provided by previous employers.
Please contact for further discussion.
Regards!
Vikas
Hi Giri -
I dont see an attachment in your bid. This can be done using regular expression .. regular expression provides a way of doing a pattern search and match ..
Regex with VBA code should make this possible. .. Possibly I can think of a regex for every group that you have explained ..
I can do a sample for you if you attached the file.
Regards
Vishy
Hi there,
I've been working with excel since before '98 and I've been using all possible versions of it.
I have many years of experience working with macros and writing code / debugging excel VBA code.
You may check my portfolio images to see few pieces of my kind of work.
(This is what I do on daily basis).
I am a professional and I can do a very good job. Also fast and accurate.
Kind Regards,
Jon
I can do that for you. Macro should identify duplicates ( which might not be an exact match but has one or more word common to both. Non duplicate could contain exact match of words or characters but might contain an uncommon word.
the macro should identify duplicates as " true" ( not unique)
the macro should identify non duplicates as "false" (unique)