Completed

Excel VBA Checking Duplicates and delete duplicates

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.

Skills: Excel, Visual Basic, Data Processing, Visual Basic for Apps, Data Entry

See more: excel combining delete duplicates, merge excel documents delete duplicates, merge excel files delete duplicates, merge excel sheets delete duplicates, delete duplicates access vba, access delete duplicates vba function, merge excel spreadsheets delete duplicates, excel vba find duplicates, partial duplicates excel vba, macro delete duplicates excel, merge delete duplicates excel 2007, concatenate delete duplicates excel, excel concatenate cells delete duplicates, delete duplicates excel contact list, outlook vba delete duplicates, excel vba remove duplicates from current selection, excel vba find duplicates in multiple columns, excel vba sort and delete rows

About the Employer:
( 4 reviews ) Gargzdai, Lithuania

Project ID: #31036427

Awarded to:

(844 Reviews)
8.9

33 freelancers are bidding on average $121 for this job

(467 Reviews)
8.4
(264 Reviews)
8.2
leelakalidas32

Hello sir I have checked the project details with attachements , i can create excel which will solve this kind of problem . please contact me so we can talk more thanks.

$250 USD in 3 days
(916 Reviews)
8.2
bouslimi1979

Hi, I checked the excel file and the 2 txt code files. The description of requirements are a little bit confusing. What do you mean by 80% ? what do you mean by 1A+3A+5A ? Do you need to apply the 2 codes, or why they More

$100 USD in 2 days
(332 Reviews)
7.9
khushh07

Hello Greetings to you!! I am an Excel (Macro)/Visual Basic expert and interested to work with your project. I have checked your requirements and that makes complete sense to me. I assure you of a high-quality job. Ple More

$75 USD in 2 days
(355 Reviews)
7.4
(327 Reviews)
6.6
(147 Reviews)
6.8
(131 Reviews)
6.1
(32 Reviews)
5.6
(39 Reviews)
6.1
yadavexpert53

Dear Employers, I can assist you in “Excel VBA Checking Duplicates and delete duplicates” the best way & according to your project need. I am an expert and professional in MS Excel Formulas & VBA (Automation by macros) More

$99 USD in 1 day
(46 Reviews)
4.9
nblsoft

Hi there, I am interested in your project and offer my services. The project you've posted about is what I do, usually. Please send me a message so that we can discuss further. Looking forward

$140 USD in 7 days
(10 Reviews)
4.9
Barroga17

Hi I am an expert in Excel and VBA application. I can help you with this task fast and accurate. Contact me to discuss. Regards!

$30 USD in 1 day
(31 Reviews)
4.7
raghibmth

Sir, Checking duplicate and delete it in better way... Expert in excel VBA... I have clearly read and understood the description of this project. I'm confident to do this work better and also on time with revisions. B More

$30 USD in 1 day
(46 Reviews)
4.5
(38 Reviews)
4.4
zemanielmustapha

hello sir, I am laureat of a high school of engineer with a good experience in this field, I develop very well by VBA Excel. I read your description carefully, and I understood your need, I can offer you a good soluti More

$200 USD in 7 days
(10 Reviews)
4.1
Sunitav36

Dear Client, i have checked the Project : Excel VBA Checking Duplicates and delete duplicates I can handle this in my best practices and professional [login to view URL] message me to discuss the work. Ready to start immedia More

$60 USD in 1 day
(23 Reviews)
3.8
arunodaya123

HI, Hope you doing well, I am qualified and experienced senior VBA/RPA Developer having 12+ years of experience in developing automation projects, I has done tons of projects similar to your requirement using VBA. I ca More

$50 USD in 1 day
(7 Reviews)
2.9
indrajitpaul

Hello, I am a VBA programmer. I can help you with a code module based on artificial intelligence logic. It will be VBA code itself, so no worries. But the algorithm to find the duplicates would be different. So, what I More

$210 USD in 7 days
(2 Reviews)
2.3
anmolmakkar666

Hey There.i am an expert in Excel VBA LETS DO IT NOW with 100% Result........ I am available right now to discuss the project! I will start right now very perfectly.

$40 USD in 1 day
(4 Reviews)
1.5