Return result (parts) for unique value in cell with multiple parts in several rows

[Tupelo1984]

Dear all,
I am looking for a formula that can return a result based on which part numbers belong to a unique sales order number.
Example:
I am trying to identify for the first column (=unique sales order number) if this order contains apples or pairs or apples and pears. If the order does not contain apples nor pears I also want the result to return, No Apples or Pears Order. The expected result should show in the 3rd column.

Unique Sales Order #	Product type	Expected Result (Type of Order)
123	Apples	Apples and Pears Order
123	Apples	Apples and Pears Order
123	Pears	Apples and Pears Order
456	Apples	Apples Order
456	Appels	Apples Order
456	Apples	Apples Order
789	Pears	Pears Order
789	Pears	Pears Order
789	Pears	Pears Order
112	NA	No Apples or Pears Order
112	NA	No Apples or Pears Order
112	NA	No Apples or Pears Order

Thanks in advance,
Tupelo

 

[Tupelo1984]

A better image now including the columns...

 

[Radoslaw Poprawski]

is this what u wanted?

Book4
	A	B	C
1	Unique Sales Order #	Product type	Result:
2	123	Apples	Apples and Pears Order
3	123	Apples	Apples and Pears Order
4	123	Pears	Apples and Pears Order
5	456	Apples	Apples Order
6	456	Apples	Apples Order
7	456	Apples	Apples Order
8	789	Pears	Pears Order
9	789	Pears	Pears Order
10	789	Pears	Pears Order
11	112	NA	No Apples or Pears Order
12	112	NA	No Apples or Pears Order
13	112	NA	No Apples or Pears Order
Sheet1

Cell Formulas
Range	Formula
C2:C13	C2	=IF(B2="NA","No Apples or Pears Order",CONCAT(TEXTJOIN(" and ",TRUE,UNIQUE(FILTER($B$2:$B$13,$A$2:$A$13=A2)))," Order"))

 

[Tupelo1984]

Hi Radoslaw, this is great - thank you so much!

 

[Radoslaw Poprawski]

glad to be of help