Looking for an EXCEL wizard

Zamknięty Opublikowano 3 lat temu Płatność przy odbiorze
Zamknięty Płatność przy odbiorze

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 Przetwarzanie danych Visual Basic Wprowadzanie danych

Numer ID Projektu: #25742968

O projekcie

31 ofert Zdalny projekt Aktywny 3 lat temu

31 freelancerów złożyło ofertę za $77 w tym projekcie

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 w ciągu 1 dnia
(412 Oceny)
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 Więcej

$140 NZD w ciągu 1 dnia
(408 Oceny)
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 Więcej

$100 NZD w ciągu 1 dnia
(280 Oceny)
7.1
bilalmaher053

Hi, u need formula under Surfacing Date column ?

$100 NZD w ciągu 1 dnia
(259 Oceny)
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 Więcej

$100 NZD w ciągu 1 dnia
(61 Oceny)
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 Więcej

$80 NZD w ciągu 2 dni
(54 Oceny)
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 Więcej

$69 NZD w ciągu 1 dnia
(137 Oceny)
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 Więcej

$45 NZD w ciągu 1 dnia
(25 Oceny)
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 Więcej

$140 NZD w ciągu 4 dni
(37 Oceny)
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 Więcej

$50 NZD w ciągu 1 dnia
(18 Oceny)
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 w ciągu 3 dni
(6 Oceny)
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 Więcej

$70 NZD w ciągu 1 dnia
(2 Oceny)
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 Więcej

$30 NZD w ciągu 1 dnia
(6 Oceny)
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 Więcej

$31 NZD w ciągu 3 dni
(2 Oceny)
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 Więcej

$30 NZD w ciągu 1 dnia
(6 Oceny)
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 Więcej

$140 NZD w ciągu 7 dni
(1 Ocena)
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 w ciągu 2 dni
(1 Ocena)
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 w ciągu 7 dni
(0 Oceny)
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 w ciągu 2 dni
(0 Oceny)
0.0
Fshrouuk88

$$$$$$

$156 NZD w ciągu 3 dni
(0 Oceny)
0.0