Google Sheets Class > #22 GAME OVER

[Kiki]

I did what you said and it says error where I typed =UNIQUE(

First you sorted the sheet by the wrong column. You sorted it by column A.
I undid that.

Go back and sort it by column B and THEN you need to add the closing ) to your formula to complete it but you have that in the wrong cell too.
Move it to I2 instead of H3.

 

[Lovely Lettie]

First you sorted the sheet by the wrong column. You sorted it by column A.
I undid that.

Go back and sort it by column B and THEN you need to add the closing ) to your formula to complete it but you have that in the wrong cell too.
Move it to I2 instead of H3.

View attachment 3285572

Okay thanks.

 

[Duckpip]

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

 

[Kiki]

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

View attachment 3285889

Yes!
You created a list of people who entered the contest in column I based on the names in column B.

 

[Kiki]

Guess what's coming up next?

Wouldn't you like to know how many times each person entered the contest without having to count each entry?

 

[Kiki]

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.

 

[Bakbuk]

Done!

 

[Kiki]

Done!

Sometimes there are multiple ways to do the same thing.
I think that if I ever plan on doing another "faker" class I will think it through before I start the thread.

 

[Kiki]

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?

 

[Bakbuk]

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?

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