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