Hello, everyone. I was hoping someone here could help me figure this out. I've been going crazy trying to figure it out myself.
I need to create a formula that grabs all of my items in a certain type of category into a separate sheet. Here is what I mean.
Input Sheet
| item_|_type|
|_1___|__A_|
|_2___|__A_|
|_3___|__B_|
|_4___|__B_|
|_5___|__B_|
|_6___|__C_|
|_7___|__C_|
Output Sheet:
item
3
4
5
Can anyone help with this? Thanks in advance
Bookmarks