Do some Excel Work: Remove duplicates, split data

Durum: Closed
Ödül: £60
Alınan Girdiler: 48
Kazanan: MRDzA

Winner

Yarışma Özeti

Split address data into 5 columns.
Spilt names data into 2 columns.

Example attached. There are c. 9K records.

Aranan Beceriler

Winner

Benzer Yarışma İlan Et

İşveren Geribildirimi

“I could not be happier with my experience in dealing with Mihailo. His communication was excellent. He gave me the confidence that he understood the task by asking relevant questions throughout and updating on progress. Best experience using freelancer in 3 years, I will use again. ”

georgepowell, United Kingdom.

Genel Açıklama Panosu

mNorbert
- 10 yıl önce
Hello,

I’m a student, web designer and developer currently based in Szczecin, Poland (Europe). I'm freelancer specializing in webdesign and branding. I'm interested in cooperation with you. I can offer designing website and slicing project to html and css.

I’ve started doing professional works in webdesign in 2007. As the time has passed, experience allowed me to craft my skills. I’ve been constantly trying to improve every day. I’m technically proficient, easy to work with and I love my job. So what are you waiting for?

Thanks for considering me for your project and I am excited being associated with you. My projects are featured on behance.net and webdesignserved.com

PORTFOLIO:
www.behance.net/norbert
www.mierzwa.org
- 10 yıl önce
sanjay9873650143
- 10 yıl önce
Hi,
I have experience in Excel. I can do in the specified time with 100% Accurcy
- 10 yıl önce
evrkiyer
- 10 yıl önce
I have experience in Excel. I am interested in the job.
- 10 yıl önce
meg221
- 10 yıl önce
I m willing to work for the job. Pls can u send the record file so that I can send the output file Asap if possible.
- 10 yıl önce
MRDzA
- 10 yıl önce
I think contest winner has been chosen. Really don't know why you apply anymore?
- 10 yıl önce
mmf0
- 10 yıl önce
I'm interesting too for this kind of jobs . Please give me some works to do. Thank you.
- 10 yıl önce
hemadhevi
- 10 yıl önce
hi sir,
i have experience in this work. if ur interested in my profile contact i can finish the job at the earliest possible..
- 10 yıl önce
KiranVBA
- 10 yıl önce
I have checked your Example.xlsx files, we can split the names in to title, first name and last name and also for address column. i just need those 9K files you want to convert. how can i get the input file (9K records) to start this work.
- 10 yıl önce
arvind13101983
- 10 yıl önce
Hi, I do not see any sample file enclosed. But I can comfortably do this job. Please describe what should I do to get this job? Thanks,
- 10 yıl önce
mantislin
- 10 yıl önce
Hi sir, I can do this for you. can you send 100 example records then I will do it at first? btw I will create script auto do it. thanks, kimi
- 10 yıl önce
1. Yarışma Sahibi
  - 10 yıl önce
  I don't think a script will work with the address but would with the name.
  - 10 yıl önce
vidurawijethunga
- 10 yıl önce
I'm new to freelancer.. but i can do your work.. how can i join this?
- 10 yıl önce
Aldo21
- 10 yıl önce
Hi, im interested in the proyect, I have previous successful experience in advanced excel.
- 10 yıl önce
MRDzA
- 10 yıl önce
Data entry job will be finished in maximum one week after start, not so expensive, but quality and accuracy 100% sure!

I am newly registered freelancer from Montenegro, I have good knowledge of English language, very good at MS Office... I hope we can make good deal for both of us...
- 10 yıl önce
holicow
- 10 yıl önce
Ready to jump in.
Regards
- 10 yıl önce
uumairkhalid
- 10 yıl önce
Please give me details
- 10 yıl önce
rameshlsawant
- 10 yıl önce
Sir , I am interested in this work. Please give me an opportunity
- 10 yıl önce
uumairkhalid
- 10 yıl önce
Hi.. I m Excel Expert. Interested in your project. I assure you 100% accurate and good quality work. let me know if you want sample before awarding. lets start. Regards
- 10 yıl önce
theempire
- 10 yıl önce
I used to help Marketing and Sales department with this kind of task. They buy a contact from an outsource company and there're a bunch of duplicated and they requires me to remove all of these duplicate (as I remembered after the filter there're only 20% of them is useful). I believe this is also your case, so you can't realize that file on the internet ;) By the way, what I will do is to find a definition of the duplication. Then sort it by my definition. Finally, I'll use a simple sorting algorithm (no need to use macro, just a normal Excel function - if, index,....) and filter out all duplicates. There are a total of 10 Excel file, each contains about 200k records and it took me about 4 hours to filter out all the duplicate of 10 Excel file. I believe the time will be the same for you.
- 10 yıl önce
SWAPANCHOWHAN
- 10 yıl önce
i can do this for you...how much data you have?
- 10 yıl önce
binaryromel
- 10 yıl önce
Hello George, I'm expert in Advance Excel. I can do this. Please check my profile.
- 10 yıl önce
quickprocess
- 10 yıl önce
Can you give me some data, then i will provide u sample work. Regard
- 10 yıl önce
dablu11
- 10 yıl önce
I'v check your sample work.

Please provide me whole file.
- 10 yıl önce
1. Yarışma Sahibi
  - 10 yıl önce
  i'm not able to release our data to the internet for obvious reasons
  - 10 yıl önce
2. dablu11
  - 10 yıl önce
  Please inform me, how I get your data file?
  - 10 yıl önce
saqmushi786
- 10 yıl önce
Hi George,

Hope you are doing great!

How soon you want this assignment to start! What specifically you are looking into the candidate in terms of skills.

Hope to hear from you soon on this.

Best regards,
Mushtaq
- 10 yıl önce
kalyankumar900
- 10 yıl önce
Waiting for your replies. :)
- 10 yıl önce
fivesky55
- 10 yıl önce
Hi Sir,
So if can't provided or release date on the internet, how are we gonna have this job done?
Is that means contest winner get it privately?
By the way, I am new on Freelancer too and I am interested on this job.

Thanks and Have a Nice Day.
Kimi
- 10 yıl önce
sandgrand
- 10 yıl önce
Dear Sir/Madam, I am a manager of a leading multinational company in sri lanka,and i am looking for a data entry job to b done,I have a excellent command in English and also an expert in Ms.Word/Excel/power point/Internet etc........(Ms Office),Will promise to do my duties at the given time promptly if the opportunity is given to me. Looking forward in hearing a favorable answer at your earliest, Regards Reniska
- 10 yıl önce
1. Yarışma Sahibi
  - 10 yıl önce
  Sandgrand you don't seem to have any exp. Have you recently joined freelancer?
  - 10 yıl önce
nashwa5
- 10 yıl önce
please provide me with the file
- 10 yıl önce
1. Yarışma Sahibi
  - 10 yıl önce
  i'm not able to release our data to the internet for obvious reasons
  - 10 yıl önce
An1man1ac
- 10 yıl önce
Attach the whole file, please
- 10 yıl önce
1. Yarışma Sahibi
  - 10 yıl önce
  i'm not able to release our data to the internet for obvious reasons
  - 10 yıl önce
Hika2Iao
- 10 yıl önce
where is your whole file ?
- 10 yıl önce
1. Yarışma Sahibi
  - 10 yıl önce
  It's on my hard drive
  - 10 yıl önce
samykhalil
- 10 yıl önce
plz add example of current data not the target format
- 10 yıl önce
1. Yarışma Sahibi
  - 10 yıl önce
  i'm not able to release our data to the internet for obvious reasons
  - 10 yıl önce
revolancer
- 10 yıl önce
Hello,
How many records you wanted to convert?
- 10 yıl önce
1. Yarışma Sahibi
  - 10 yıl önce
  as stated, 9k
  - 10 yıl önce