Use simple logic formula:
So, we got a simple excel data table (50 rows of records) with a list of cars that have passed Two types maintenance works (Corrective and Overhauls) with various recorded dates and correlating mileage.
The Task is to apply Excel Logical Formula to find out:
At what mileage the each car had a First "Corrective" instance work before the "Overhaul" date and First "Corrective" mileage instance after the "Overhaul" date.
Need explanation of applied formula.
Please see table attached.
Thank you
Hello, I’m an Excel expert and I would like to help you with your formula. Please check my profile and contact me to discuss.
Stay tuned, I'm still working on this proposal.
I am an Excel expert specializing in complex formulas and macros. I am confident that I can accomplish the task at hand because I have a solid logic foundation.
Hi
I would like to bid for this project. I posses Data Analytics, Accountancy, Administration and Content Writing experience with Advance MS Excel Dashboards, MS &
Google Office, WordPress and Touch Typing 60wpm Skills.
Hi..
I am interested to your project .
I believe that I'll do this work properly and in timely .
I am agree with your budget.
And I'm sure that I'll finish the task with your full satisfaction .
Lets start a trial to prove me for the project .
I look forward to your response.
All the best.......
I HAVE JUST FINISHED YOUR TASK. Award me to send you the file and explain you what I did. I didn't use pivottables. By the way, there is a duplicated row (car 3168, overhaul - the rows 22 and 23 are identical). I'm online now.
Relevant Skills and Experience
MS Excel: Advanced
Logical thinking: Advanced
English: Near-native
Proposed Milestones
$25 USD - Job done.
i have good command over Ms excel especially pivot table, charts, advance formulas etc. i can do this. Do let me know more detail
Relevant Skills and Experience
Ms excel
Proposed Milestones
$25 USD - upon completion
I can deliver a result in short time for this job.
Relevant Skills and Experience
Excel in one of my specialties, I can do this job fast and ensuring quality in the delivery, I know how work with macros and functions that make easier to get a result.
Proposed Milestones
$12 USD - Documented formula
Dear Sir
I read your message carefully. I understand your project. Some Days ago I have completed the same task.
I agree to your proposal. I can ensure 100% quality my job
Relevant Skills and Experience
Excel
Proposed Milestones
$25 USD - Please create a milestone
Bonsoir
je suis excellent sur tout ce qui concerne excel peogrammation vba sur excel pour creer des macros logiciel de gestion telque sage ligne 100
merci