filter with multiple and or criteria

[raaj11]

Hi i am trying to list all product and product code and quantity where location is "Melbourne" Quantity > 0 and Product_State = New + if product is in melbourne and quantity is 0 but product code exist in column "j" that should also be included in the result. i got the first part working with formula =UNIQUE(FILTER(F:H,(B:B="Melbourne")*(H:H<>"0")*(D:D="NEW"))) but could not figure out the second part to include if product is in melbourne and quantity is 0 but product code exist in column "j" that should also be included in the result.

 

[myall_blues]

Good news. Thanks for responding.