excel formula to find the result from the 3 column with criteria

Dear experts

i have data set mainly C ,E,F Columns have serial no in C:C ,order relase date E:E , parts type in F:F with three four conditions

i have set of two so's number repeats with different ORDER RELEASE DATE in E:E, formula calculates depends upon first date of so and Parts Type.

Condition-1
"If Serial No Two And If Parts Type Is ""Parts Calls"" For Two Serial No I Want For First Parts Calls As Per Date Result ""Needs To Be Billing"", For The Second Parts Calls As Per Second Date Result ""RR No Billing"".

Condition-2
"If Serial No Two And If Parts Type Is ""Labour Calls"" For Two Serial No I Want For First Parts Calls As Per Date Result ""Needs To Be Billing"", For The Second Parts Calls As Per Second Date Result ""RR No Billing"".

Condition-3
"If Serial No Two And If Parts Type Is ""Labour Calls"" For First Serial No As Per First Date And If Parts Type Is ""Parts Calls"" As Per Second For First Serial No I Want For First Parts Calls As Per Date Result ""Needs To Be Billing"", For The Second Parts Calls Result ""Needs To Be Billing"".

Condition-4
"If Serial No Two And If Parts Type Is ""Parts Call"" For First Serial No As Per First Date And If Parts Type Is ""Labour Calls"" As Per Second For First Serial No I Want For First Parts Calls As Per Date Result ""Needs To Be Billing"", For The Second Parts Calls Result ""RR No Billing"".

find the attachment you may clear of doubts

any experts give solution for this?

my excel dude

almost tried with this formula to get result even i got struck with holy expected result!!!!

=IF(E3=MIN(IF($C$3:$C$26=C3,$E$3:$E$26,$F$3:$F$26="PARTS CALLS")),"NEEDS TO BE BILLING","RR NO BILLING")

make this formula changes !!!

Find the attachment solve my problem dudes''''

Dude

simple logic every serial no exactly repeats twice in C:C column ok then date can be two date for first so and second so then in the F:F column there might be
PARTS CALL OR LABOUR CALLS

CONDITION 1
IF For two So's have Parts status is PARTS CALLS Means i want result for first min date of So's = "NEEDS TO BE BILLING" and second so Result = "RR NO BILLING"
CONDITION 2
IF For two So's have Parts status is LABOUR CALLS Means i want result for first min date of So's = "NEEDS TO BE BILLING" and second so Result = "RR NO BILLING"
CONDITION 3
If First Só's Have first Parts status is Labour Calls for first so as per first min date result "NEEDS TO BE BILLING"
If Second So's Have Parts status is Parts Calls for second so as per second date "NEEDS TO BE BILLING"
CONDITION 4
If First So's Have first parts as per min date is "Parts Calls" I want result for the first so Result "NEEDS TO BE BILLING"
If Second So's have parts status for second date is "Labour Calls "I want result for the second so "RR NO BILLING"

Find the attachment of first dont look at second you may confuse help me dude

Wow thanks dude

any experts please help on this???

any experts helps i am looking for?