See sample data attached. I'm looking a formula to check the data in column A and column F . In column A is the order number and column F is where the product is being sourced from. I need a formula to quickly check these two columns and if all of the products are being sourced from the one location insert a Yes.

See example below hopefully the formula would check and return false for order number 100023 and yes for order number 100024

Order Number location Formula
100023 Factory False
100023 Shop False
100023 Factory False

100024 Factory Yes
100024 Factory Yes
100024 Factory Yes

Thanksexample2.xlsx