Suoritettu

Write some Software

Job Description:

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 [url removed, login to view] 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

[url removed, login to view]

First_Last

[url removed, login to view]

F_Last

FirstL

First.L

First_L

[url removed, login to view]

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.

Taidot: Excel

Tietoa asiakkaasta:
( 83 arvostelua ) Oconomowoc, United States

Projektin tunnus: #9636272

Myönnetty käyttäjälle:

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 Le Lisää

$25 USD 1 päivässä
(9 Arvostelua)
2.8

6 freelanceria on tarjonnut keskimäärin $30 tähän työhön

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 3 päivässä
(33 arvostelua)
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 0 päivässä
(61 arvostelua)
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 Lisää

$27 USD 1 päivässä
(26 arvostelua)
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 u Lisää

$30 USD 2 päivässä
(12 arvostelua)
4.1