Ditutup

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

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.

Kemahiran: Excel, Visual Basic, Visual Basic untuk Aplikasi

Lihat lagi: code excel vba color alternating rows, excel vba import multiple file worksheet, convert multiple rows columns columns rows excel, excel find duplicates in multiple columns, how to find duplicate values in different excel sheets, formula to find duplicates in excel, how to find duplicates in excel, excel vba find duplicates in multiple columns, excel find duplicate rows based on multiple columns, duplicate rows in excel, excel find duplicates with multiple criteria, excel vba exporting multiple worksheets, incrementing rows excel vba, send automated emails excel vba outlook, sum multiple cells excel vba, excel vba exporting data multiple sheets, summing multiple rows excel, sum grouped rows excel vba, excel vba sum multiple conditions, excel vba extract data multiple worksheets

Tentang Majikan:
( 7 ulasan ) Singapore, Singapore

ID Projek: #17977163

40 pekerja bebas membida secara purata $30 untuk pekerjaan ini

TonmoyRoy111

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

$50 USD dalam sehari
(273 Ulasan)
6.5
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 Lagi

$55 USD dalam 3 hari
(172 Ulasan)
6.5
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 dalam 3 hari
(62 Ulasan)
6.4
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 Lagi

$30 USD dalam sehari
(62 Ulasan)
5.7
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 Lagi

$30 USD dalam sehari
(75 Ulasan)
5.5
aubrey03

I am an Excel and VBA specialist. I have a lot of experience in creating automation tools, dynamic dashboards and macros in Excel. You may check some of my projects here: [login to view URL] Lagi

$30 USD dalam sehari
(54 Ulasan)
5.1
ilkecokay

Hello, excel expert here. What you ask is easy for me and i'm willing to do it for a fair price. I prefer doing the work first and accepting the job later. So if you message me, i'll start doing,finish it, if you someh Lagi

$20 USD dalam sehari
(17 Ulasan)
4.2
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 Lagi

$30 USD dalam 3 hari
(8 Ulasan)
3.8
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 Lagi

$30 USD dalam sehari
(14 Ulasan)
3.4
wiisetech

Hi, I can do this for you. I understand what you require. I will do it according to your instructions and [login to view URL] for your reply for more info. Regards.

$33 USD dalam 2 hari
(12 Ulasan)
3.3
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 Lagi

$50 USD dalam 5 hari
(15 Ulasan)
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 Lagi

$45 USD dalam 2 hari
(4 Ulasan)
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 Lagi

$35 USD dalam 0 hari
(11 Ulasan)
2.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 Lagi

$30 USD dalam sehari
(2 Ulasan)
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 dalam sehari
(2 Ulasan)
1.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 dalam sehari
(1 Ulasan)
0.8
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 Lagi

$20 USD dalam sehari
(1 Ulasan)
0.8
MaruguMo

Hello, This can either be done via code (long method), where the code goes through all the cells in all the rows, doing substrings for cells with multiple email addresses and comparing the substring with the second ro Lagi

$25 USD dalam sehari
(0 Ulasan)
0.0
DeacyAmp

Would like to do the job, but need some additional information. Will I get the original data or at least a sample? Do you prefer xls, xlsm format? Hope to hear from you soon. Kind regards, Daniel Relevant Skills and E Lagi

$25 USD dalam 2 hari
(0 Ulasan)
0.0
VICTOR430

I'm proficient in Excel and VBA. I charge low because I want to start working as a Freelancer. I can help you

$15 USD dalam sehari
(0 Ulasan)
0.0