Google Sheets: If formula return only non-blank cells

[qwzky]

Hi, community. I feel this is easy, but can't seem to figure out how I can "import" only names that contain a "yes" value:

Book1
	A	B	C
1
2	Student	Graded
3	Mark	yes
4	Vanessa
5	Betty	yes
6	John	yes
7	Timothy
8
9
10
11
12
13	Graded students:
14	Mark
15		← i want that out of my list
16	Betty
17	John
18
19
Sheet1

Cell Formulas
Range	Formula
A14:A19	A14	=IF(Sheet1!B3="yes",Sheet1!A3,"")

 

[Fluff]

How about

+Fluff 1.xlsm
	A	B
1
2	Student	Graded
3	Mark	yes
4	Vanessa
5	Betty	yes
6	John	yes
7	Timothy
8
9
10
11
12
13	Graded students:
14	Mark
15	Betty
16	John
17
18
19
Main

Cell Formulas
Range	Formula
A14:A19	A14	=IFERROR(INDEX($A$3:$A$8,AGGREGATE(15,6,(ROW($A$3:$A$8)-ROW($A$3)+1)/($B$3:$B$8="Yes"),ROWS(A$14:A14))),"")

 

[Joe4]

If only they had Excel 365!
This is really easy with the Filter function!

=FILTER(A3:A7,B3:B7="yes")

 

[qwzky]

If only they had Excel 365!
This is really easy with the Filter function!

Actually, I am using GSheets. It seems to recognize the function, but then it returns me the error REF. Is there a way to do that in order to "import" that list to another sheet?

 

[Joe4]

Actually, I am using GSheets.

That is a very important detail that you want to be sure to mention in your thread title and/or original post!
While there are many similarities, Excel and Google Sheets are NOT the same thing, and do have differences.

Please also note that you do NOT want to post Google Sheets questions in the "Excel Forum".
Use the "General Discussion & Other Application" forums, as is detailed in the description of that forum:

I have never used Google Sheets, so I cannot really comment on what it can and cannot do.

 

[qwzky]

now I know I really didn.t know that those were different.