Looking for an EXCEL wizard

종료 등록 시간: 3년 전 착불
종료 착불

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

엑셀 데이터 처리 비쥬얼 베이직 데이터 입력

프로젝트 ID: #25742968

프로젝트 소개

31 건(제안서) 재택 근무형 프로젝트 서비스 이용 중: 3년 전

이 일자리에 대한 프리랜서 31 명의 평균 입찰가: $77

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 (1일 이내)
(412 리뷰)
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 기타

$140 NZD (1일 이내)
(408 리뷰)
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 기타

$100 NZD (1일 이내)
(280 리뷰)
7.1
bilalmaher053

Hi, u need formula under Surfacing Date column ?

$100 NZD (1일 이내)
(259 리뷰)
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 기타

$100 NZD (1일 이내)
(61 리뷰)
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 기타

$80 NZD (2일 이내)
(54 리뷰)
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 기타

$69 NZD (1일 이내)
(137 리뷰)
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 기타

$45 NZD (1일 이내)
(25 리뷰)
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 기타

$140 NZD (4일 이내)
(37 리뷰)
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 기타

$50 NZD (1일 이내)
(18 리뷰)
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 (3일 이내)
(6 리뷰)
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 기타

$70 NZD (1일 이내)
(2 리뷰)
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 기타

$30 NZD (1일 이내)
(6 리뷰)
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 기타

$31 NZD (3일 이내)
(2 리뷰)
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 기타

$30 NZD (1일 이내)
(6 리뷰)
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 기타

$140 NZD (7일 이내)
(1 리뷰)
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 (2일 이내)
(1 리뷰)
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 (7일 이내)
(0 리뷰)
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 (2일 이내)
(0 리뷰)
0.0
Fshrouuk88

$$$$$$

$156 NZD (3일 이내)
(0 리뷰)
0.0