Need an excel VBA that can highlight duplicate emails for multiple rows.

Cerrado Publicado hace 5 años Pagado a la entrega
Cerrado Pagado a la entrega

Need an excel VBA that can highlight duplicate emails for multiple rows.

I know Excel's built in "highlight duplicate" already highlights the exact value of 1 cell to another.

But what I need is a little different:

Some of my cells contain only 1 email ad, while some contains multiple email ad in one cell, separated by semicolons.

What I need is to highlight a cell that contains multiple emails, even if only one of its email is a duplicate of other cells.

Example:

-One cell contains "aaa@[login to view URL];bbb@[login to view URL];ccc@[login to view URL]"

-Another cell only contains "bbb@[login to view URL]"

-The excel VBA will then highlight both cells because both of them contains bbb@[login to view URL]

This will be used on about 50,000 rows of cells so it is very important that the code is clean so it does not lag.

Excel Visual Basic Visual Basic para aplicaciones

Nº del proyecto: #17977163

Sobre el proyecto

36 propuestas Proyecto remoto Activo hace 5 años

36 freelancers están ofertando un promedio de $31 por este trabajo

TonmoyRoy111

Hello client I understand what you need from the project. I can write the code for you. Please contact me. Roy

$50 USD en 1 día
(432 comentarios)
7.2
polarjin2017

Hello? How are you? I have good skills in So I can complete your job in time. Hope to work with you. Thank you.

$55 USD en 3 días
(95 comentarios)
6.7
avinav606lx

Hello there, Can you share your template? if you have. I have developed more than 500 VBA macros for Windows/MAC I am an expert in Excel/Word/PowerPoint/Outlook VBA/Python with over 5+ years of experience. Ping m Más

$55 USD en 3 días
(176 comentarios)
6.5
supper5guy

Hello there, as an expert in excel and VBA, i can help you to accurately develop such a VBA code for highlighting duplicate emails as you have specified. Please contact me and let us talk more about your project. Thank Más

$30 USD en 1 día
(83 comentarios)
5.8
Sercho56

I can easily achieve what you are asking for. I have significant experience in Text and String Parsing and will write you an efficient and effective code to match your email addresses. I can also account for any chan Más

$30 USD en 3 días
(26 comentarios)
5.6
nagybatonyi

Hi, I have a university degree in economics and IT, and several decades of system design and programming, in the recent decade especially in Excel and VBA. In my approach you'll have an opportunity to consult deta Más

$30 USD en 1 día
(64 comentarios)
5.7
GopalJp

Hi, I can do this project. Please come on freelancers chat to discuss more. Looking to listen from you. Thanks Gopal

$20 USD en 2 días
(15 comentarios)
4.6
dataexplorer

"Hello, I am happy to inform you that I have read your current project description and understood all of your required requirement. I'd like to help you with confidence and satisfying results. I have professional wor Más

$50 USD en 5 días
(18 comentarios)
4.3
gpnr2017

Hello, Hope you are doing well. I have gone through the project requirement and find my self in good position to complete this project using excel macro/VBA. A brief summary of my profile as following. Over 12 yea Más

$20 USD en 1 día
(11 comentarios)
4.0
smb310570

Assuming that the data is in range A1:A10. Here is the macro. It can be changed as per requirement. Sub MyDup() Dim txt As String Dim Str() As String For J = 1 To 10 txt = Cell Más

$30 USD en 1 día
(14 comentarios)
3.4
odeskmuktadir

Hello Hope that you are doing good. I am very interested in this job because my skill refers to the job. I have a vast knowledge ofexcel macro and VBA I am new to the Freelancer but I can assure you that, I can Más

$45 USD en 2 días
(5 comentarios)
3.4
Gajacrafty

Hai this is Gajendran, I’m having good experience in Excel Macro. Based on your project description I will update all your required details and provide you the best data, will complete this task within time limits. I’m Más

$35 USD en 0 días
(17 comentarios)
3.0
Wantse

Hello, I have a solution. What I can do is use a dictionary with VBA, it will assist to detect duplicates in cells. Kind regards, Justin

$30 USD en 1 día
(4 comentarios)
1.6
schandraindya

I would like to take this opportunity to introduce myself. My name is Satish Chandra and I have held several senior level positions during my professional career spanning over 18+ years. I have around 5+ years of exper Más

$30 USD en 1 día
(2 comentarios)
1.6
rubal45

i will help you to sort this problem. i can write vba code for this . thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks thanks

$30 USD en 1 día
(2 comentarios)
1.0
Justivan53

Hi I can help you with this project. I have many years of experience in VBA Coding. I can provide you a solution in a day or two. My main goal is right now is to collect good reviews, Best Regards Ivan

$25 USD en 1 día
(0 comentarios)
0.0
GKEvans

Hello, I have 14 year experience working with excel including macros. My experience comes from working in accounts where it is important that work is performed accurately but efficiently..

$30 USD en 2 días
(0 comentarios)
0.0
AdibaQudoos

Hello I have already done many projects like this for marketing campaign running companies. i can provide you code in a very short period of time. I am new here at this site, offering you minimum rate to build my p Más

$15 USD en 1 día
(0 comentarios)
0.0
mirazulmahin

Dear Sir, I have 4 years more experience in data entry, excell,, microsoft word, wordpress, social media manager and many more. This is my first bid. If you want to try me for complete this work first time. Maybe you'r Más

$35 USD en 3 días
(0 comentarios)
0.0
quangtrantpq

Hello Sir, I'm Quang from Vietnam. I have 3 year working experience, and also have experience working with vba in excel and autocad, so I belive that I can do this job well. And I'm new here so I will get u a good pri Más

$25 USD en 1 día
(0 comentarios)
0.0