Завершено

Excell 2007 vba macro addition remove comma in find dupes simple addition

I have a Macro that I use and works well, it finds duplicate words in a cell and puts them in the next cell so I can edit

so if the cell had

big red dog with big collar ------ it would put ---- big big in next cell

but if it was

big, red dog with big collar

then it sees big, with the comma as a separate word

there may also be other characters causing issues but so far only seen comma, so provision for others would be required

this is the macro I am using now,

Sub FindDuplicates()

Dim i As Long

Dim j As Integer

Dim k As Integer

Dim WS As Worksheet

Dim WordArr As Variant

Dim DubStr As String

Dim WordCount As Integer

Set WS = ActiveSheet

'Loop cells

For i = 4 To [login to view URL]([login to view URL], 1).End(xlUp).Row

'Split cell words into array

WordArr = Split([login to view URL](i, 4).Value, " ")

'Loop through each word in cell

For j = LBound(WordArr) To UBound(WordArr)

WordCount = 0

'Count the occurrences of the word

For k = LBound(WordArr) To UBound(WordArr)

If UCase(WordArr(j)) = UCase(WordArr(k)) Then

WordCount = WordCount + 1

End If

Next k

'Output duplicate words to string

If WordCount > 1 And InStr(1, DubStr, WordArr(j)) = 0 Then

DubStr = DubStr & WordArr(j) & " "

End If

Next j

'Paste string in column B

[login to view URL](i, 6).Value = Trim(DubStr)

DubStr = ""

Erase WordArr

Next i

End Sub

Квалификация: Ввод данных, Обработка данных, Excel, Visual Basic, Visual Basic для приложений

Показать больше how to delete duplicates in excel but keep one, excel remove duplicates keep first instance, remove "duplicate values within a cell", how to remove duplicates in excel, excel remove duplicate rows based on one column, remove duplicate words in excel cell, excel remove duplicates not working, excel remove duplicates formula, save pdf 2007 vba, access 2007 vba fileexists, access 2007 vba print pdf file, access 2007 vba examples free, extract documents excell 2007, pdf access 2007 vba, access 2007 vba print report file, access 2007 vba save report pdf, access 2007 vba, access 2007 vba macro save pdf file, outlook 2007 vba macro processing last received mail, macro body outlook 2007 vba

О работодателе:
( 1 отзыв ) Romford, United Kingdom

ID проекта: #18560737

Поручен:

nwss1986

Hi, I can do the macro modification and can deliver in a couple of hours. Please reply me, if interested. I can start right now. Thanks.

£16 GBP за 0 дней(-я)
(85 отзывов(-а))
5.5

10 фрилансеров(-а) в среднем готовы выполнить эту работу за £15

prameswara

Hello Sir Im excel VBA macro and formula Expert :) im very interested to solve your case Sir please ping me now and im able to start working now Thank you Galih

£20 GBP за 1 день
(341 отзывов(-а))
7.0
VladimirLilenko

Hello, dear sir! I registered at the forum not so long ago, but I already have several completed projects on www.freelancer.com. I am ready to carry out your project in the reasonable price and in the shortest possibl Больше

£20 GBP за 0 дней(-я)
(81 отзывов(-а))
5.9
madnanayoub

Hi, I am computer science graduate with more than 3 years of programming experience in VBA programming that is used by Excel Macros. I have understood your requirement and yes i can edit your macro and it will work as Больше

£10 GBP за 1 день
(31 отзывов(-а))
4.9
Mokshith30

Hi I have Read Your Requirements I am Excel VBA Expert Experianced in VBA Macros & Web Scraping Script... I can finish any kind of vba task in 1 day only pls see my previous projects for my vba experiance T Больше

£10 GBP за 0 дней(-я)
(18 отзывов(-а))
3.6
zexhan1

Hi, Thanks for sharing your requirement here at freelacner and I will be more than happy to help you. I have 5 to 6 years’ experience in this fields. I am expert in it & I have much free time for your project. Th Больше

£10 GBP за 1 день
(1 отзыв)
0.0
theatasolution1

Dear Employer, I am ready to work on your required task and can also give 100% satisfaction. Looking forward to an opportunity to work with you. Warm Regards: Theata Solution

£13 GBP за 1 день
(0 отзывов(-а))
0.0
summairmir56

I have an English and ms office and also a programming skill and I have good match for your project …………..

£18 GBP за 2 дней(-я)
(0 отзывов(-а))
0.0
£18 GBP за 10 дней(-я)
(0 отзывов(-а))
0.0
abhisheksura

This is an easy fix and should not take more than an hour. I will code it to ignore any special characters that appear at the end of the word.

£18 GBP за 1 день
(0 отзывов(-а))
0.0