Find Jobs
Hire Freelancers

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

$10-30 USD

Закрито
Опублікований over 5 years ago

$10-30 USD

Оплачується при отриманні
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.
ID проекту: 17977163

Про проект

36 пропозицій(-ї)
Дистанційний проект
Активність 5 yrs ago

Хочете заробити?

Переваги подання заявок на Freelancer

Вкажіть свій бюджет та терміни
Отримайте гроші за свою роботу
Опишіть свою пропозицію
Реєстрація та подання заявок у проекти є безкоштовними
36 фрілансерів(-и) готові виконати цю роботу у середньому за $31 USD
Аватарка користувача
Hello client I understand what you need from the project. I can write the code for you. Please contact me. Roy
$50 USD за 1 день
4,9 (432 відгуки(-ів))
7,2
7,2
Аватарка користувача
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 за 3 дні(-в)
4,8 (95 відгуки(-ів))
6,7
6,7
Аватарка користувача
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 me to discuss project , timeline and budget. Thanks A
$55 USD за 3 дні(-в)
4,9 (176 відгуки(-ів))
6,5
6,5
Аватарка користувача
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. Thanks
$30 USD за 1 день
5,0 (83 відгуки(-ів))
5,8
5,8
Аватарка користувача
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 changes in case (ie, if something is entered as AAA@AAA it can match with aaa@aaa).
$30 USD за 3 дні(-в)
5,0 (26 відгуки(-ів))
5,6
5,6
Аватарка користувача
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 details with me, to test pilot solutions if necessary in order to achieve an optimal final solution. Further use of macros, fixing of bugs and minor changes are included in the bid without any additional fees. I have great experience in any kind of data manipulation with Excel/VBA. I am a full-time freelancer, I can start working on the project immediately. If you open a chat I can immediately send you a working mockup doing the job and it shows you the row number of the next occurrence of the duplicated addresses as an extra. This mockup uses only built-in Excel functions but my bid includes also the macro inserting the necessary formulas and conditional formatting in your live file. Regards
$30 USD за 1 день
4,9 (64 відгуки(-ів))
5,7
5,7
Аватарка користувача
Hi, I can do this project. Please come on freelancers chat to discuss more. Looking to listen from you. Thanks Gopal
$20 USD за 2 дні(-в)
5,0 (15 відгуки(-ів))
4,6
4,6
Аватарка користувача
"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 working here with 100% results and more creative and innovative ideas for our clients. I've worked on several similar projects before. I'm offering my services for more than five years in the field of Excel, Internet Research, Leads, Research, Web Search. I have a team with eight members. They can get the required data manually from the website. If you need the data to be scrapped then also I can do scrapping and put them into excel sheet. I am very responsible towards my clients and I can complete the task within time with cent percent accuracy. Regards "
$50 USD за 5 дні(-в)
5,0 (18 відгуки(-ів))
4,3
4,3
Аватарка користувача
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 years of experience in IT field of software development and support. On technical front I have good experience on following technologies. Databases : SQL Server, Universe/Unidata, Oracle,MS Access. Development Technologies: C#,Winform, WPF, ASP.Net MVC, Pick Basic/UniBasic, Visual Basic 6, Excel VBA. Reporting/Designer Tool: SSRS, Crystal Reports, System Builder(SB+). I would very much enjoy having the opportunity to talk with you further to discuss the requirements and expectations regarding the project, and how I could use my skills to benefit you. Thank you for considering my application. I look forward to hearing from you. Regards, Naveen Upadhyay
$20 USD за 1 день
5,0 (11 відгуки(-ів))
4,0
4,0
Аватарка користувача
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 = Cells(J, 1).Text Str = Split(txt, ";") For I = 0 To UBound(Str) For K = J + 1 To 10 If InStr(Cells(K, 1).Text, Str(I)) <> 0 Then 'MsgBox Cells(K, 1).Text With Cells(K, 1).Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 65535 .TintAndShade = 0 .PatternTintAndShade = 0 End With With Cells(J, 1).Interior .Pattern = xlSolid .PatternColorIndex = xlAutomatic .Color = 65535 .TintAndShade = 0 .PatternTintAndShade = 0 End With End If Next K Next I Next J End Sub
$30 USD за 1 день
5,0 (14 відгуки(-ів))
3,4
3,4
Аватарка користувача
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 do this project very carefully within the provided time. I can manage 40 hours in a week for this job and i think i am the right person for your job. I am mostly online on Skype. Pls have a voice chat. Looking forward to hearing from you. Best regards Muktadir Hussain
$45 USD за 2 дні(-в)
4,3 (5 відгуки(-ів))
3,4
3,4
Аватарка користувача
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 interested in your project, kindly give an opportunity to do the same. Thanks in advance.
$35 USD за 0 день
5,0 (17 відгуки(-ів))
3,0
3,0
Аватарка користувача
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 за 1 день
5,0 (4 відгуки(-ів))
1,6
1,6
Аватарка користувача
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 experience handling 8 teams PAN India as a Senior Manager. Besides this, I am an expert in Visual Basic for Applications (VBA - Macros) for automating complex Excel based reports. I am also an expert in data visualization tools like Tableau. I also have developed a few applications in Android Studio for Android platform which involves writing code in native Java and XML. I have also successfully completed the course in PMP from Simplilearn earning 35 Personal Development Units (PDUs) and will be appearing for the PMP certification exam scheduled for 4th December, 2018. I have keen interest in Six Sigma, TQM and management methodologies like PDCA, Herzberg's X and Y theory, McGregor's Hygiene theory and am a protagonist of Kanban, Kaizen and Continuous Improvement. If given a chance, I’ll prove to be an asset to your revered Organization. Thanks & Regards, Satish Chandra
$30 USD за 1 день
4,8 (2 відгуки(-ів))
1,6
1,6
Аватарка користувача
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 за 1 день
5,0 (2 відгуки(-ів))
1,0
1,0
Аватарка користувача
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 за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 за 2 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 profile Hope to work togather looking forward
$15 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 the lucky man for me. Please sir try me and check my best experience. thanks
$35 USD за 3 дні(-в)
0,0 (0 відгуки(-ів))
0,0
0,0
Аватарка користувача
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 price. Contact me please!
$25 USD за 1 день
0,0 (0 відгуки(-ів))
0,0
0,0

Про клієнта

Прапор SINGAPORE
Singapore, Singapore
5,0
7
На сайті з черв. 15, 2013

Верифікація клієнта

Дякуємо! Ми надіслали на вашу електронну пошту посилання для отримання безкоштовного кредиту.
Під час надсилання електронного листа сталася помилка. Будь ласка, спробуйте ще раз.
Зареєстрованих користувачів Загальна кількість опублікованих робіт
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Завантажуємо для перегляду
Дозвіл на визначення геолокації надано.
Ваш сеанс входу закінчився, і сеанс було закрито. Будь ласка, увійдіть знову.