Google Sheets: Select and show some cells

[Ayman93]

Hi, I'm trying to do some things with excel Google Sheets but I'm having some problems.
My first question is this: What if I want to show some cells based on the value of another, for example how can I show those numbers just if there's yes in the next cell?
I don't want to filter them because I need to have them like this in other cells, this is an example of the result that I want to get:

So if b2 is yes show a2, if b3 is yes show a3 etc. and I don't want to have blank cells between the numbers

 

[jasonb75]

There are many ways to do that, with excel 2019 this is probably the easiest.

Book1
	A	B	C
2	1	Yes	1
3	2	No	3
4	3	Yes	5
5	4	No
6	5	Yes
7
Sheet1

Cell Formulas
Range	Formula
C2:C6	C2	=IFERROR(AGGREGATE(15,6,$A$2:$A$6/($B$2:$B$6="Yes"),ROWS(C$2:C2)),"")

 

[Rick Rothstein]

1) Are the numbers in Column A really 1, 2, 3, etc. or are those just simplified stand-in values for what is really there?

2) Is the first cell with a value in Row 1 or Row 2?

 

[Ayman93]

I can't use Jason's solution because I'm using google sheets and aggregate is not supported, I'm sorry maybe I should specify it.

Yes Rick, is just a simplified example.
The real case is that I have some names in the column A, yes or no in column B, and I need to extrapolate those names that have yes in the column B.

 

[stockman256]

I don't know much about google sheets, but in excel this would work (put in cell c2 and copy down):

=if(b2="Yes",insert your formula to calculate the value in c here,"")

"" will give you a blank for cell C2 unless B2 =yes, you could also enter a 0 or another formula if you want if that condition is false

 

[jasonb75]

With sheets, perhaps

=FILTER(A2:A10,B2:B10="Yes")

Also, there is a separate section of the forum for google sheets questions (General discussion and other applications). I'll put in a request for this one to be moved for you.
As you rightly said though, it would be better to specify it in your question to avoid any possible confusion.

 

[Joe4]

Yes, your first post was a little misleading too, as you started off saying:

Hi, I'm trying to do some things with excel but I'm having some problems.

If you want to post Google Sheets questions, you will want to post them to the forum that Jason mentioned AND be sure to make it clear in your thread title and/or first post that it is, in fact, a Google Sheets question. I will update your thread title so that it is clear to others who may try to help.