Đang Thực Hiện

MS Excel expert to split data across cells and remove duplicates

IMPORTANT: Only respond if you are Excel expert.

See demo attached. This is just an extract from the file to be used.

Names Sheet:

Task 1: Remove Duplicate records. A duplicate is where Registered Service Provider AND Head Office AND Telephone values are the same. End result is to have a single record for each set of duplicates.

Task 2: Split address values in a single cell split into 5 cells of Address line 1, Address line 2, City, State, Postcode.

Task 3: Groups Tan

Remove Duplicates. A duplicate is where the Registered Service Provider AND the Group values are the same.

Goal is to have a single record for each Registered Service Provider and Group combination.

When bidding send a note saying "I am an excel expert" so I know you read the spec.

Kỹ năng: Excel

Xem thêm: freelancer ms excel expert required, ms excel expert vacancies pune maharashtra, ms excel expert vacancies mumbai maharashtra, ms excel expert jaipur rj, need ms excel expert in nagpur, need an excel expert to organize some data for me i need t, ms excel expert, ms excel expert delhi delhi, i need an excel expert to organize some data for me i need to combine a long list of 1000 items into model units etc this is a s, excel remove duplicates, excel expert to organize data, excel expert exploratory data analysis data visualization, excel grab cells data, data analysis excel expert needed, excel file india state city, split data multiple sheets excel, remove duplicates excel file access, excel list country state city, excel expert data analysis, vba excel sumup specific cells data, merge excel sheets remove duplicates, vba split excel data, remove duplicates keep data access, remove duplicates excel mail merge, excel remove duplicates merge info

Về Bên Thuê:
( 29 nhận xét ) Rose Bay, Australia

Mã Dự Án: #13124632

Đã trao cho:

vsprybhanu

"I am an excel expert" Hi, Experienced Excel Macro Developer. I have read your instructions carefully. I have developed an Excel VBA Program to Remove all duplicate records. Please send me message to get Thêm

$60 AUD trong 1 ngày
(42 Đánh Giá)
4.7

76 freelancer đang chào giá trung bình $92 cho công việc này

TypingxpertRehan

i am an excel expert, ok sure, i understand, and in next few hours i will get this done with 100% accuracy you bet, please share me full file, the sample is all clear, thx

$126 AUD trong 1 ngày
(911 Đánh Giá)
8.7
FINGERRPRINT

I am an excel expert. Row 10 and 11 are duplicate in demo file, I can remove duplicate and split the address in 5 column and get you the spreadsheet accurately. Have done this many time before. Looking forward to work Thêm

$105 AUD trong 1 ngày
(157 Đánh Giá)
7.2
mantislin

Dear sir, I am scraping expert, I have did too many scraping projects, please check my reviews then you will know. Can you tell me more details? then I will provide example data/script for you. Thanks, Thêm

$97 AUD trong 2 ngày
(91 Đánh Giá)
6.5
hdlong66

"I am an excel expert" Hello. I have completed 6 similar projects and would like to provide my service on this task. Kindly refer to my similar projects at [url removed, login to view] Thêm

$100 AUD trong 3 ngày
(100 Đánh Giá)
6.7
BithiXpert

A proposal has not yet been provided

$100 AUD trong 3 ngày
(142 Đánh Giá)
6.2
hatemfreelance4

“Budget and project period are flexible to meet to your requirement” I’m an Electrical Engineer. I am very interested in Web search and data input task and also i have a good experience in this field. I am responsib Thêm

$83 AUD trong 1 ngày
(63 Đánh Giá)
5.5
privani

I am an excel expert Over the period of 10 years, I have done plenty of data cleaning which includes removing duplicate records and splitting and merging data. I checked out your file. I can definitely do this fo Thêm

$40 AUD trong 1 ngày
(30 Đánh Giá)
5.0
MdAlamgirHoosain

"I am an excel expert" Dear Hiring Manager, I have gone through your job-posting and become very eager to work with you.I Have a team.I am a hard worker and very [url removed, login to view] main goal is to gain my client's satisfac Thêm

$49 AUD trong 3 ngày
(61 Đánh Giá)
5.1
sonarkaushik

*** I am an excel expert Sir,      I am well versed in this kind of jobs and can do your project as per requirement. I have over 8 years of experiences. I am very much able to work on this. ***I am ready to start Thêm

$99 AUD trong 1 ngày
(40 Đánh Giá)
5.6
binitkumar200022

I am an excel expert. I can start to work now and complete at the earliest possible. Will work at your rate. Thanks, Binit

$30 AUD trong 3 ngày
(24 Đánh Giá)
5.1
Vasilchenko

Hello I am an excel expert. Lets work..............................................................................

$70 AUD trong 1 ngày
(42 Đánh Giá)
5.1
vladimirmefremov

I have conducted similar tasks and even more advanced in my past engagements. I will use the MID and SEARCH functions to split the addresses into multiple fields and also sort functions to remove the duplicate values. Thêm

$155 AUD trong 3 ngày
(7 Đánh Giá)
5.0
inspireplatinum

I am an excel expert Have taken a look at your file. Have done complex projects such as building whole systems using vba, e.g. forecast systems, accounting systems etc. Able to do the splitting of your data expedi Thêm

$90 AUD trong 2 ngày
(9 Đánh Giá)
4.7
standarditech

"I am an excel expert" Hi, I have taken a deep look on this project, and I am sure that we can work together. I have experienced in these kind of task. Please give me a chance to serve you and i will never let you dow Thêm

$30 AUD trong 1 ngày
(63 Đánh Giá)
4.7
nadimvicky

I am an Excel expert.I am working as a design engineer and I have experience of preparing calculation in excel sheet.I have good knowledge of excel.

$35 AUD trong 2 ngày
(10 Đánh Giá)
4.6
$83 AUD trong 1 ngày
(21 Đánh Giá)
4.5
nevo1234

I am an excel expert Dear sir I am an expert in excel and also I am an economist (BA+MBA) by profession. I have vast experience in excel and VBA and i am confident i can assist you with your requirements. feel Thêm

$50 AUD trong 2 ngày
(12 Đánh Giá)
4.0
nimesha1994

I am an excel expert Hi, I'm very interested to do your project. I have great knowledge on about your project. I have already read your description and I feel like I would be a great fit for the project. I can Thêm

$50 AUD trong 3 ngày
(6 Đánh Giá)
4.2
AhmedMarzoq

"I am an excel expert" ـــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــــ

$50 AUD trong 1 ngày
(12 Đánh Giá)
4.2
SayTechSolution

I am an excel expert We are running a small Business with our expert operators. We are providing cost effective and quality service to our clients since April 2015. We would like to work on this project. Let me know i Thêm

$100 AUD trong 3 ngày
(28 Đánh Giá)
4.2