Print returned array

[grifdoogindoggy]

I am looking for a way to print a returned array for a specific criteria.

For example, if the following values in a column do not equal 0, I would like to return them and print them in another column. I do not want to use a Macro.

i.e.
0
0
0
0
Apples
0
0
Oranges
0
0


Values: "apples","oranges"


Is this an index function? Thank you for any help.

 

[Eric W]

Try:

Book1
	A	B	C
1	List		List2
2	0		Apples
3	0		Oranges
4	0
5	0
6	Apples
7	0
8	0
9	Oranges
10	0
11	0
12
Sheet6

Cell Formulas
Range	Formula
C2	=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$20)/($A$2:$A$20<>0),ROWS($C$2:$C2))),"")

 

[grifdoogindoggy]

Thank you! Is there a way I can tighten this up so that
i.e.
0
0
0
0
Apples
Apples
0
0
Oranges
0
0

Only returns
Apples
Oranges

And not apples twice?

 

[grifdoogindoggy]

Never mind this, I can just filter it.

 

[Eric W]

Filtering works, you can also change the formula to:

=IFERROR(INDEX(A:A,AGGREGATE(15,6,ROW($A$2:$A$20)/(($A$2:$A$20<>0)*(COUNTIF($C$1:$C1,$A$2:$A$20)=0)),1)),"")