-
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.
How to filter material base on product
- Thread starter ADEYADEEL
- Start date
Oaktree
MrExcel MVP
- Joined
- Jun 20, 2002
- Messages
- 8,120
- Office Version
- 365
1) On Sheet2, add a column that pulls in the list of products that include each material:
Something like:
Copy C4 down through the end of your materials
2) Filter column C for "Product B"
Something like:
Code:
C4=TEXTJOIN("; ",TRUE,IF(Sheet1!$B$2:$B$7=A4,Sheet1!$A$2:$A$7,""))Copy C4 down through the end of your materials
2) Filter column C for "Product B"
Upvote
0
Similar threads
- Question
