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.
30 freelancers are bidding on average $24 for this job
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.
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
The formula was very simple. You just need pivot table and if formula Relevant Skills and Experience Expert in ms Excel Proposed Milestones $15 USD - Create formula and its explanation Seems like all clear