Formula Help

Closed
Shaun - 11 Aug 2011 à 14:21
rizvisa1 Posts 4478 Registration date Thursday 28 January 2010 Status Contributor Last seen 5 May 2022 - 11 Aug 2011 à 18:11
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 28 January 2010 Status Contributor Last seen 5 May 2022 766
11 Aug 2011 à 18:11
The best solution would be to filter the data on "N" and copy and paste the visible cells