Google Sheets Class > #22 GAME OVER

[Kiki]

You can only get that second view with the dimensions if you save all the pics to your computer. Right?

Yes.

 

[Kiki]

Oh. I picked a couple as square. I think they were just about landscape but very, very close to square. Should I go back and make them landscape?

Yes.

 

[RoyalChick]

Wait, I think my row looks different than yours...

View attachment 3285207

The text circled is on row 3 for me.

Yes me too. And didn’t we freeze the first three rows in an earlier lesson? Well we did because that is what the grey line means under row 3.

 

[RoyalChick]

Assignment 19

CREATE A UNIQUE LIST OF NAMES OF PEOPLE WHO ENTERED THIS FAKE CONTEST.

CLICK IN CELL I2.
TYPE
=UNIQUE(
THEN highlight the cells I have highlighted in orange (B2 through B28)
View attachment 3285200

Notice that when you highlight them this (in red below) will appear next to your first open (
=UNIQUE(B2:B28

Next type ) and hit enter.
View attachment 3285201

Done. But my unique names show up in alphabetical order and your are in some other order.

 

[RoyalChick]

I don't think that this was supposed to happen...

View attachment 3285889

That is what I have. Pretty nifty. I like the unique thing. Cool.

 

[RoyalChick]

Assignment 20

Cell J2

Type =COUNTIF(
now after you type the opening parenthesis go highlight the column B.
When you highlight COL B you are telling it to find all of the exact "names" in that column only and count them.

highlighting Column B will add this to your formula in cell J2:
B:B



so far you have this in cell J2:
=COUNTIF(B:B


next type a comma , and then you are going to tell it the exact word you are looking for it to count.

after the comma type "Kiki" then the closing parenthesis and hit enter.


=COUNTIF(B:B,"Kiki")

Repeat these steps for the rest of the list in column J.

View attachment 3286035

Done. Is it OK that I did a short cut so I didn’t need to type each name? You can just click on the name in column I (which for me was Bakbuk not Kiki because mine came out alpha sorted) and then I just copied it down.

 

[RoyalChick]

Takes you to the bottom left of the stuff you've typed in.

Yup. Done.

 

[Kiki]

Done. Is it OK that I did a short cut so I didn’t need to type each name? You can just click on the name in column I (which for me was Bakbuk not Kiki because mine came out alpha sorted) and then I just copied it down.

View attachment 3290358

Sure!

 

[Kiki]

Done. But my unique names show up in alphabetical order and your are in some other order.

It's supposed to be in alphabetical order.

 

[RoyalChick]

Is class finished? Did we learn everything?