Closed

Excel Logic Formula

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

Skills: Excel

See more: excel logical functions with examples pdf, and function excel, logical functions in excel 2007 with examples pdf, if function excel multiple conditions, logical functions in excel definition, multiple if statements in excel, logical functions, excel if and or function together, want to do excel work, Do excel work, do excel work!, free online racing car creator racing game, racing car flash graffics, racing car flash graphics, racing car tut flash

About the Employer:
( 2 reviews ) upland, United States

Project ID: #15308002

32 freelancers are bidding on average $23 for this job

$30 USD in 0 days
(301 Reviews)
6.9
P0L

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.

$30 USD in 1 day
(239 Reviews)
6.9
$25 USD in 1 day
(95 Reviews)
6.0
aubrey03

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.

$30 USD in 1 day
(22 Reviews)
4.9
ritvijpandey872

A proposal has not yet been provided

$30 USD in 1 day
(12 Reviews)
4.2
khudammunir

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 More

$20 USD in 1 day
(15 Reviews)
4.2
anzarulislam

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 More

$30 USD in 1 day
(10 Reviews)
4.0
SergioAlfaroV

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 onl More

$25 USD in 0 days
(3 Reviews)
4.0
dongmei1993

I have a good skills in Excel. Moreover I'm familiar with mathematics. Stay tuned, I'm still working on this proposal.

$25 USD in 1 day
(2 Reviews)
3.8
mpunn2007

A proposal has not yet been provided

$30 USD in 1 day
(8 Reviews)
3.1
Softeria

Excel expert.....Message me Stay tuned, I'm still working on this proposal.

$50 USD in 2 days
(10 Reviews)
3.3
$11 USD in 1 day
(1 Review)
3.2
OGSpain

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 More

$36 USD in 1 day
(4 Reviews)
2.7
mofajjelbd

Excel Logic Formula Relevant Skills and Experience Excel Proposed Milestones $10 USD - milestones

$10 USD in 1 day
(6 Reviews)
2.7
haleem0786

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

$25 USD in 1 day
(7 Reviews)
2.8
zakii

100% On Time 100% On Budget 100% Satisfaction Relevant Skills and Experience Microsoft excel Proposed Milestones $25 USD - Milestone

$25 USD in 1 day
(3 Reviews)
2.1
frankrui

A proposal has not yet been provided

$15 USD in 1 day
(3 Reviews)
1.6
shub0000

Expert i excel

$25 USD in 2 days
(1 Review)
1.1
febryanhikmat

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

$15 USD in 1 day
(0 Reviews)
0.0
nitinthokchom

7 years on-site work experience using excel

$28 USD in 1 day
(0 Reviews)
0.0