Google Sheets Class > #22 GAME OVER

[Kiki]

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

YES!
When we have hundreds of rows of crap to scroll through it takes too much time to scroll (for me) so this is a faster way to get to the bottom of info to add more.

 

[Kiki]

@Lovely Lettie I just fixed your error so you can't start over with 19.

You had two names in column B that had a space at the very beginning of the name. That space was throwing the alphabetical sort list off and duplicating some of the names in your column I.

 

[Duckpip]

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

You're not at the top of my list, and it became out of order when I sorted it A-Z.

 

[Kiki]

You're not at the top of my list, and it became out of order when I sorted it A-Z.

Hold let me log in and look.

 

[Kiki]

You're not at the top of my list, and it became out of order when I sorted it A-Z.

You already fixed it? It looks correct to me.

 

[Duckpip]

You already fixed it? It looks correct to me.

I'm not sure if I fixed it, but I thought it looked different than yours. My bad, then.

 

[Duckpip]

Alright, done.

 

[Duckpip]

TIP 1
Control + HOME button will take you to the top left cell of your sheet
Control + END takes you to the bottom left cell of the sheet


Assignment 21

Click in cell A1 then click CONTROL + the down arrow button.
Which cell do you end up in when you do this?

Cool, you can use that to scroll up, too. (Well, kind of.)

 

[casportpony]

18 part 2 Sort by one column
19 Create a unique list
20 Countif Count the entries

Tip 1 AND Assignment 21

Done, but I did 19 and 20 on a new tab.
https://docs.google.com/spreadsheet...T8dAeXgbrvETWI8hi3LaWM7aY/edit#gid=1972100479

 

[Bakbuk]

Done, but I did 19 and 20 on a new tab.
https://docs.google.com/spreadsheet...T8dAeXgbrvETWI8hi3LaWM7aY/edit#gid=1972100479

She didn't dub you class clown for nothing.