Google Sheets: If formula return only non-blank cells

qwzky

Board Regular
Joined
Jul 22, 2021
Messages
53
Office Version
  1. 2021
  2. 2016
Platform
  1. Windows
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
ABC
1
2StudentGraded
3Markyes
4Vanessa
5Bettyyes
6Johnyes
7Timothy
8
9
10
11
12
13Graded students:
14Mark
15 ← i want that out of my list
16Betty
17John
18 
19 
Sheet1
Cell Formulas
RangeFormula
A14:A19A14=IF(Sheet1!B3="yes",Sheet1!A3,"")
 

Excel Facts

How to show all formulas in Excel?
Press Ctrl+` to show all formulas. Press it again to toggle back to numbers. The grave accent is often under the tilde on US keyboards.
How about
+Fluff 1.xlsm
AB
1
2StudentGraded
3Markyes
4Vanessa
5Bettyyes
6Johnyes
7Timothy
8
9
10
11
12
13Graded students:
14Mark
15Betty
16John
17 
18 
19 
Main
Cell Formulas
RangeFormula
A14:A19A14=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))),"")
 
Upvote 0
If only they had Excel 365!
This is really easy with the Filter function!
Excel Formula:
=FILTER(A3:A7,B3:B7="yes")
 
Upvote 0
If only they had Excel 365!
This is really easy with the Filter function!
Code:
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?
 
Upvote 0
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:

1647459646088.png


I have never used Google Sheets, so I cannot really comment on what it can and cannot do.
 
Upvote 0
now I know :) I really didn.t know that those were different.
 
Upvote 0

Forum statistics

Threads
1,226,693
Messages
6,192,471
Members
453,726
Latest member
JoeH57

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top