I'm trying to create a formula that will list for me in a new set of cells all items in one column that meet the criteria in another column.
Like shown below: List 1 shows the original list, i want to make a formula that looks for all cells with "N" in column B, then enter the value from column A into column A of list 2 in the order of items on list 1 and starting at row 1 in List 2. Is this possible?
Sorry, not sure how to make the columns and rows look better in here.
1 Cat Y
2 Dog Y
3 Horse Y
4 Chair N
5 Llama Y
6 Rug N