Looking for an EXCEL wizard

Cerrado Publicado hace 3 años Pagado a la entrega
Cerrado Pagado a la entrega

I need someone to help me figure out complicated stuff in EXCEL

i need to populate a column with a sealing date

Take this scenario for example, there is a road section that is 744 meters long, the road is split into 5 different chunks because there is 5 intersections, so the road is recorded as 0 - 182, the next length of road is 182 - 397, then 397 - 557, then 557 - 668 then 668-744 for example, there is a separate table i have that tells me when the road was last sealed, but the sealing records show for example that they sealed 0-744 in 2014, and sealed 0-668 in 2019

I dont know how to add a sealing date to my road record when there is no unique IDs to work from. see attached spreadsheet that contains the surface data and the working out columns

Excel Procesamiento de datos Visual Basic Entrada de datos

Nº del proyecto: #25742968

Sobre el proyecto

31 propuestas Proyecto remoto Activo hace 3 años

31 freelancers están ofertando un promedio de $77 por este trabajo

P0L

Hello, I am an Excel/VBA expert and I would like to help you with your project. Please check my profile and contact me to discuss further details. Regards.

$100 NZD en 1 día
(412 comentarios)
7.6
prameswara

Hello Sir Im excel VBA macro and formula Expert :) i can do make macro for your scenario for split road to different area/range please ping me now for discuss more and im able to start working right now after all clear Más

$140 NZD en 1 día
(408 comentarios)
7.3
elqueabandona

Hi, how are you?, my name is Cristian and i am Excel/VBA expert. Excel wizard here! You can see my previous work and the comments that employers have left me in the following link: https://www.freelancer.com/u/elquea Más

$100 NZD en 1 día
(280 comentarios)
7.1
bilalmaher053

Hi, u need formula under Surfacing Date column ?

$100 NZD en 1 día
(259 comentarios)
6.9
RavinduJayzz

Hey there! Your project jumped out at me, and I would love to help you out with it. I specialize in Excel and Workbook creation. I'm a detail-oriented person who delivers given projects on deadlines. I read thro Más

$100 NZD en 1 día
(61 comentarios)
6.1
narsim3128

NOTE : I HAVE EXPERTISE IN EXCEL MACROS AND VBA With respect to this project I would like to present myself as a candidate for your consideration. I have more than 12 years of IT experience. I have successfully comple Más

$80 NZD en 2 días
(54 comentarios)
5.8
AnowarRatul

$69 Only ----- Dear sir, I have read your project details and reviewed the attachment carefully. I can make the advance formula by maintaining 100% accuracy of your data absolutely as you want ------- Excel VBA Macro C Más

$69 NZD en 1 día
(137 comentarios)
5.6
IgeS

Hi there, Do you need a formula that will put years to column D ("Surfacing Date") of Working Out Sheet from the dates in Column N ("Surface Date") of Surface Data Sheet? This can be done using Excel built-in formul Más

$45 NZD en 1 día
(25 comentarios)
4.9
Ibrahim33

hello sir, I have the wide experience as I worked at Advice Interactive Group in Quality Assurance for Directories submissions for about three years. What I can do for you: -Data administrative assistant. -Excel (creat Más

$140 NZD en 4 días
(37 comentarios)
4.8
reubengi

Hi there, I have read your scope and the worksheet. I have the formula you can apply in the "Surface Date" column that will get the correct dates from "Surface data" sheet. I can deliver as soon as you need it. Regar Más

$50 NZD en 1 día
(18 comentarios)
4.8
VbaStudio

Hi, I'm an expert in Excel. If you don't have an ID you have to identify sections with a combination between name of the road and numbers. I think it could be done with formulas only.

$30 NZD en 3 días
(6 comentarios)
3.4
DHAVALPATEL008

Only 70$ in 1 days-Lowest bid with a high potential solution-Payment after 100% Work satisfaction I have gone through your current requirements & attached & would be happy to offer you with the required solutions. I Más

$70 NZD en 1 día
(2 comentarios)
3.4
hayteekeys

Hi, I'm a professional and expert in Data works or projects..My skills and services include: - Web scraping - Data entry - Data mining - Data processing - Excel - MySQL - Oracle -Financial Analysis -Advanced Excel -MS Más

$30 NZD en 1 día
(6 comentarios)
3.1
zhongguoswj

I have been working with excel for more than 20 years, and have been using CBA for at least 10. I enjoy Excel challenges, and this project looks interesting. I think we can work out some formulas to get you what you wa Más

$31 NZD en 3 días
(2 comentarios)
2.0
anowarbss

Dear Hiring Manager I am ready to start right now. I checked your both sheet (working out and surface data) need to more discus for populate a column with a sealing date, I am expert excel formula, please see my recen Más

$30 NZD en 1 día
(6 comentarios)
1.6
sajjadtaghvaeifr

Hi, I have PhD in mechanical engineering from Tohoku University of Japan. I have published 20 Journal papers and 16 international conference papers. I have read your Requirement. My expertise match this job. Please sen Más

$140 NZD en 7 días
(1 comentario)
1.6
PoojaGupta002

Hi there, I am an expert in excel and macros. I have gone through the project description and can help you on this project.

$30 NZD en 2 días
(1 comentario)
1.3
nabangi

I have enough experience for this assignment and prepared to take it up. I have reliable internet access and deliver projects in time.

$30 NZD en 7 días
(0 comentarios)
0.0
heshamsaber

-I am efficient in Microsoft Word, Excel, and Powerpoint. I am a hard worker, type quickly, and can ensure your data is entered accurately.I am ready to start now

$30 NZD en 2 días
(0 comentarios)
0.0
Fshrouuk88

$$$$$$

$156 NZD en 3 días
(0 comentarios)
0.0