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.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
filter with multiple and or criteria
- Thread starter raaj11
- Start date
myall_blues
Well-known Member
- Joined
- Nov 26, 2015
- Messages
- 656
- Office Version
- 365
- Platform
- Windows
Good news. Thanks for responding.
Upvote
0
Excel Facts
What did Pito Salas invent?
Pito Salas, working for Lotus, popularized what would become to be pivot tables. It was released as Lotus Improv in 1989.
Similar threads
