Formula Help

Closed
Shaun - Aug 11, 2011 at 02:21 PM
rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Aug 11, 2011 at 06:11 PM
Hello,

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.

List 1

A B
Item Animal?
1 Cat Y
2 Dog Y
3 Horse Y
4 Chair N
5 Llama Y
6 Rug N

List 2

A
1 Chair
2 Rug
3
4
5
6

Thanks

1 response

rizvisa1 Posts 4478 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 766
Aug 11, 2011 at 06:11 PM
The best solution would be to filter the data on "N" and copy and paste the visible cells
0