Need formula to get desire result from values of two column

[breadwinner]

Dear experts

I have set of column data A & B In those A contains Serial No & B contains Ticket No...

I am looking for formula to solve the function by those conditions... almost get done by countifs functions.
1.If Serial & Ticket No Only Once result should be "FIRST TIME LABOUR ONLY"
2.If Repeat Twice For The First Serial No And Ticket "Labour Only", For The Second Serial No And Ticket "Labour & Parts"
3.If Serial No Twice But Ticekt No is different for both serial no Result Should be "PART USED 1 OF 2"
4.More Than 2 Times Serial & Ticket No Repeats" Result Should Be "CCI"

Thanks in Advance

[ajryan88]

Hi,

Insert this formula in D2 and drag down to D16:

Please Login or Register  to view this content.

Workbook attached.

Hope this helps

[breadwinner]

Sir Without Function of C:C possible to get result from A&B column only into D column

[ajryan88]

Just substitute "C2" in my formula for the formula in C2:

Please Login or Register  to view this content.

[breadwinner]

Thanks Alot Works Perfectly Mission Completed....

[ajryan88]

You're welcome!

Please don't forget to mark this thread as solved, and please click on the * next to my post to say thanks