Write some Software

$10-30 USD

Completed

Posted

about 8 years ago

$10-30 USD

Paid on delivery

Create an Excel formula that looks at all the emails in the Excel sheet from the same domain and then determines the a count and percentage for each each email pattern. For example, if there are 3 emails from the domain [login to view URL] with the FLast email format, then the count is 3 and the percent is 100% for that format for that domain. If there were 3 separate email patterns for the same example, the count for each would be 1 and the percent for each would be 33.33% Here are the potential email patterns. FLast First Last FirstLast [login to view URL] First_Last [login to view URL] F_Last FirstL First.L First_L [login to view URL] FMLast LastFM Other (not matching any pattern) We will provide a sample sheet for those that bid and engage. The winning worker will get a sample of 1000+ records to test your formulas. Upon delivering it, we will need it to work on a sheet of 600,000 records. To show that you read this description fully, put the name of your favorite animal in CAPS as the first line of your response/proposal.

Excel

Project ID: 9636272

About the project

6 proposals

Remote project

Active 8 yrs ago

Looking to make some money?

Email address

Benefits of bidding on Freelancer

Set your budget and timeframe

Get paid for your work

Outline your proposal

It's free to sign up and bid on jobs

Awarded to:

@mnazmih1985

HAMSTERS :) Hello there I hope you're doing well i am excel expert , with nothing i can not make through excel please check my profile here for your reference : https://www.freelancer.com/u/mnazmih1985.html Lets discuss some more My best regards

$25 USD in 1 day

4.4

(9 reviews)

2.8

6 freelancers are bidding on average $30 USD for this job

@macroPOL

DOG, Hello, I am Excel and VBA expert. I can complete this project (macro, VBA). Please note that I have 100% completion rate and 5-star feedback on projects.

$45 USD in 3 days

5.0

(33 reviews)

4.8

@redouaneaberdin

Hi there My name is Redouane I am very interested in your project. Kindly start messaging so we can discuss further details. Thank you

$30 USD in 0 day

4.9

(61 reviews)

4.6

@rajafaizan

Hi, I can complete your project on time and within your budget. I have worked on similar projects to what you are looking for, and I am confident I can exceed your expectations. I read through the job details extremely carefully and I am absolutely sure that I can do the project very well. I am experienced Graphic Designing, MS Office, VBA, PDF and Data Entry expert. Your kind response is being awaited.

$27 USD in 1 day

4.9

(26 reviews)

4.4

@finecodervw

CAT Can you please share more details on what you mean by FLast email format. some examples will be helpful. Mentioned below is my brief profile. I am well versed with writing macros in Excel, Word etc.. I have used written macros extensively for Excel, MS Word, PowerPoint etc. for automation of various tasks. I have more than 10 years of experience to my credit. I would be happy to answer any queries that you may have. Looking forward to working with you. Thanks & Regards FineCoder

$30 USD in 2 days