Lukket

Excel Match one by one

We need to standardize 834 rows in an excel book.

The book has two sheets named "Insurance" and "Base".

The marks appearing on both sheets are already labeled with a number.

The same must be done with models, whose number is based on the "Base" sheet. Standardization should be performed according to the description of the model.

There may be the case of several models in the sheet named "Insurance" with the same model number, or various model numbers for the same model description.

There may be also the case where there is no match between the model description and the model code or number, in which case it is requested to leave a blank space in the correspondent cell.

Models that do not have similar or approximate description in the "Base" sheet should be left blank.

The first row serves as an example.

-----------------------------------------------------------------------------

Necesitamos estandarizar 834 filas de un excel.

El libro tiene dos hojas, "Banco de Seguros" y "Base".

Las marcas que aparecen en ambas hojas ya están estandarizadas con un numero.

Lo mismo hay que hacer con los modelos, cuyo numero base se encuentra en la hoja "Base". La estandarización se deberá realizar en función de la descripción del modelo. Puede darse el caso de varios modelos en la hoja "Banco de Seguros" con un mismo número de modelo o que no tengan ningún correlativo.

Los modelos que no tengan una descripción similar ni aproximada en la hoja "Base" deberán ser dejados en blanco.

Færdigheder: Dataindførsel, Databehandling, Excel

Se mere: blank model sheet, SEGUROS, Modelo , marcas, hoja, en excel, correspondent, base one, blanco, insurance data base, model based excel, match excel vba, hoja excel, macro match excel, base models, code book data entry, fuzzy match excel, model excel, data entry marks, score prediction soccer match excel, excel book, fuzzy match excel 2007, data dos excel, match excel spreadsheets product information, excel data insurance

Om arbejdsgiveren:
( 0 bedømmelser ) Uruguay

Projekt-ID: #6051878

36 freelancers are bidding on average $93 for this job

zExcel

Hi, I'll be happy to help you with this project. I will start as soon as you have awarded me the project Please feel free to message me if you need to discuss any questions

$111 USD på 1 dag
(254 bedømmelser)
7.6
deepbluetech

A proposal has not yet been provided

$100 USD på 1 dag
(169 bedømmelser)
7.2
Ibrahim185

sir, i am highly interested and dedicated to do this task. let's discuss and start. i am awaiting for your positive reply. thanks

$61 USD in 3 dage
(544 bedømmelser)
7.2
vsolcorp

Hello, Sir I am from vSol CORP. We are 19 people team, worked on more than 500 completed projects. We provide round the clock service. I have checked your project requirement. We are professional with data validati Mere

$60 USD in 2 dage
(247 bedømmelser)
7.6
maverick44000

Hi there. I am Usman and I can update the sheet according to the mentioned rule in 1 day. There is conversion from Tons to KG in both sheets. Should that be considered too ? Kindly discuss so we may proceed. Regards.

$50 USD på 1 dag
(67 bedømmelser)
6.7
Dhruvika111

Greetings! My name is Dhruvika and I am the Account manager at N-office Solutions. I have reviewed the project requirements and would like to offer our exclusive web research and data entry services to cater your requi Mere

$64 USD på 1 dag
(242 bedømmelser)
7.4
elqueabandona

Hola, mi nombre es Cristian, soy Licenciado en Administración de Empresas y trabajo todos los días con excel. Tengo mucha experiencia con planillas de calculo y formulas complejas para procesar información. Puedo reali Mere

$88 USD in 3 dage
(177 bedømmelser)
6.7
diamond247

Hello Sir, We are a well built set up with excellent skilled operator with lot of experience in this segment/skill,have complete more than 200 similar job in freelancer in last 4 years, i have gone through your proj Mere

$147 USD in 3 dage
(214 bedømmelser)
7.0
deepabittu

Hello Sir I have 5+ member team and 3 broadband [url removed, login to view] my team have good experience of data entry and seo [url removed, login to view] plz give me one [url removed, login to view]

$83 USD in 3 dage
(236 bedømmelser)
6.5
paris2785

Excel and VBA expert for over a decade. Master in Information Systems. I have delivered similar projects in the past. Please check my portfolio for: [url removed, login to view] Estate (video demonstration) [url removed, login to view] (video demonstrat Mere

$59 USD in 2 dage
(115 bedømmelser)
6.4
dpune

Hi, I have more than 14 years of exp and I am expert in this kind of work. I have completed more than 210 projects. Please look at the feedback left by my employers to know more about my work. Waiting for your positive Mere

$100 USD in 3 dage
(172 bedømmelser)
6.5
cuongtn

Please sellect me. I have experience with project like this. Please discuss, i can reduce my price.

$40 USD in 3 dage
(63 bedømmelser)
5.1
isacbogdan

Hello, I am a professional Data Processor in a multinational company and I can solve your task very fast and at a reasonable cost with a v/h-lookup formula. Kind regards, Bogdan Isac

$30 USD in 3 dage
(4 bedømmelser)
3.2
dringis

Dear, I am a new freelancer from Eastern Europe looking for Excel related projects. I work for financial services company as an analyst and looking for additional job as an Excel expert. I have broad knowledge in da Mere

$88 USD in 3 dage
(3 bedømmelser)
1.8
zeshanacca

Hello If the following is your requirement than please acknowledge because I have already started work on these lines. #1 : Description contains 12000 should have model no. of 310001 & 310002 based on base sheet Mere

$30 USD in 3 dage
(0 bedømmelser)
0.0
mso12

I am a chemical engineer by trade, and I've learned to be very proficient at Excel/VBA. I have no problem developing macros or Excel workbooks that will do exactly what you ask.

$50 USD in 3 dage
(0 bedømmelser)
0.0
HennieBarnard1

Good day, I have advanced Excel skills, I've workrd with Excel daily for the past 13 years. Day job includes recons between several large excel files. Should be straight forward to perform your required task within Mere

$133 USD in 2 dage
(0 bedømmelser)
0.0
nehaarora14

Hi, I have experience of working on excel and can deliver results within the stipulated time period.

$98 USD in 3 dage
(0 bedømmelser)
0.0
tvkamal

Hi, As a Freelancer and a Pro-active Mechanical Engineer i hereby sending my bid for this project. As a professional i know the importance of On-time delivery of Quality products and i hereby assure that i will d Mere

$35 USD in 2 dage
(0 bedømmelser)
0.0
ahmedmahmod95

Hello, I can do this simply. and really i need this jop for my study I hope i can do what do you want me to do . and hope you help me to get this. Thanks a lots.

$155 USD in 3 dage
(0 bedømmelser)
0.0