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.
36 freelancers are bidding on average $93 for this job
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
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.
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]
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
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
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.
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.