Ditutup

Remove reoccurring words in a column using EXCEL VBA

Remove reoccurring words in a column using EXCEL VBA

I need a VBA script in excel to remove specific words in a cell occurring more than X amount of times in a specified column.

For example:

Reoccurring words to remove:

- Table

- Chair

- candle

The max number of times a word can occur for column A is 1

The max number of times a word can occur for column B is 2

Column A shows ‘product name’

Column B shows ‘product description’

The script needs to run through each columns A and B, and remove any words that reoccur more than the allowed amount specified.

The VBA needs:

- To be easily inserted and installed into other excel workbooks

- The ‘remove words and reoccurring limit’ should be specified by me and changed regularly without affecting the script

-

Thanks

Richard

Kemahiran: Pemprosesan Data, Excel, Kejuruteraan Perisian, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: excel vba remove character from cell, excel vba remove characters from string, excel vba remove text from cell, excel vba remove text from string, remove duplicate words in excel cell, excel vba remove specific text from cell, macro to delete text in a cell, how to remove part of text in a cell in excel vba, loading csv access using excel vba, write xml data file using excel vba, close skype application using excel vba, getting data as400 using excel vba, creating web pages using excel vba, accessing web pages using excel vba https, connect access using excel vba, calculate salary using excel vba, projects using excel vba, accessing web pages using excel vba, web scraping using excel vba, access ftp using excel vba

Tentang Majikan:
( 3 ulasan ) Auckland, New Zealand

ID Projek: #17117356

38 pekerja bebas membida secara purata $30 untuk pekerjaan ini

jaylancer43

Hello Sir, I am a full time freelancer and can work dedicated on this till completion. My name is Jay and I'm an Expert Excel and VBA programmer on freelancer.com and have been featured by the freelancer community ( Lagi

$51 NZD dalam 0 hari
(585 Ulasan)
8.2
schoudhary1553

Hello, I can help with you in your project Remove reoccurring words in a column using EXCEL VBA . I have more than 5 years of experience in Data Processing, Excel, Software Architecture, Visual Basic, Visual Basic Lagi

$51 NZD dalam sehari
(253 Ulasan)
7.5
$28 NZD dalam 0 hari
(339 Ulasan)
7.7
ksriniravi

Greetings Richard! Being a full time freelancer working exclusively on Excel based projects, I work on developing such solutions every single day. I can come up with VBA script as per requirements. I have 18 year Lagi

$30 NZD dalam sehari
(150 Ulasan)
6.6
dpune

Hi, I have more than 14 years of Excel/VBA exp. Let us discuss more details so that I can estimate cost and time better. I have completed more than 310 projects. Please look at the feedback left by my em Lagi

$30 NZD dalam 2 hari
(166 Ulasan)
6.5
danielgpratidya

Hi, I've created a trial version for you based on your screenshot at: [login to view URL] Simply click on "Remove Words" button, and it will search Lagi

$30 NZD dalam 0 hari
(202 Ulasan)
6.6
$56 NZD dalam 3 hari
(164 Ulasan)
6.5
MohsanEijaz

I am interested in your project, I can complete it now. Mohsan

$30 NZD dalam sehari
(69 Ulasan)
6.0
archanaoswal

I have excellent command on MS Excel and can write the macro to remove the recurring words as per the limits specified. I have completed complex projects in Excel before . For instance - Get match details, odds and Lagi

$40 NZD dalam sehari
(47 Ulasan)
5.5
abhinovpankaj

Hello, I have been working as freelancer since last ~ 5 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Lagi

$31 NZD dalam sehari
(65 Ulasan)
5.6
prabakarm23

Greetings for the Day!!! I have 8 years of experience in .NET, VBA Macros, VB script,PS Script and VB creation with application like SAP, Internet explorer, Microsoft Outlook,PDF& Text files, MS Access and SQL Se Lagi

$56 NZD dalam 3 hari
(64 Ulasan)
5.1
nwss1986

Hi there, I can give you a script that can be easily worked out on your own on any number of excel files to remove the words. I can start right now and can deliver in a few hours. Thanks.

$22 NZD dalam 0 hari
(69 Ulasan)
5.2
dvcontact

Hi, I have read very carefully your project details about witting an editable Excel VBA that will remove reoccurring words allowing some certain number of words in each column. I am absolutely sure that I can complete Lagi

$30 NZD dalam sehari
(28 Ulasan)
5.3
Ranitani9

Hello I am interested in your project as I have done many projects of excel like yours. Quality, accuracy and timely work delivery is guaranteed. For further discussion please msg me. regards Tanzeela.S

$31 NZD dalam sehari
(23 Ulasan)
4.5
sajidkhan45

Hi, I am an excel VBA expert and would like to help you with this task. I have done many jobs like these. Please go through my profile and reviews so that you can be confident about me. Can you please share with Lagi

$28 NZD dalam sehari
(22 Ulasan)
4.4
TetyanaS

The examples of my codes you can see in my books. I'm the author of this book (VBA and VB .NET): [login to view URL] I conduct lectures and laboratory classes with students in the course “VBA and VB .NET”

$35 NZD dalam 3 hari
(23 Ulasan)
4.7
sloker18

I am proficient with excel macro/VBA development, I can write the macro to clean up the reoccurring word as specified in your project, I am available to start your project right away, feel free to message me if you are Lagi

$28 NZD dalam sehari
(25 Ulasan)
4.2
$28 NZD dalam sehari
(14 Ulasan)
4.2
atifarzi

I can do this for you in 1 day. It is pretty simple task. Hope we can build a working relationship. I am looking for good reviews and good employers to get work consistently.

$20 NZD dalam sehari
(24 Ulasan)
4.1
maximwang8661

nice to meet you. your project is very interesting to me. If you hire me, I can start working for you right now. And I will complete your project qualitatively and in time. I have a good experience in excel and exc Lagi

$28 NZD dalam sehari
(8 Ulasan)
4.1