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
Bookmarks