Google Sheets Class > #22 GAME OVER

[Lovely Lettie]

I found the problem. The problem is that some of the member names you pasted have spaces after them, and some do not. It counts words with extra spaces as different words.

Space	No Space
View attachment 3300315	View attachment 3300313

To remove the extra spaces, select the whole page by clicking the upper left box:
View attachment 3300310

Then Data>Data cleanup>Trim whitespace
View attachment 3300309

Thank you
How do I do this on a phone? I haven't got my computer ATM

 

[Summer_]

I considered joining at times, But then didn’t for some reason

 

[RoyalChick]

I considered joining at times, But then didn’t for some reason

Looks like you still have time - just start at the beginning. I learned some useful stuff. Now I am just waiting for my diploma!

 

[Summer_]

Looks like you still have time - just start at the beginning. I learned some useful stuff. Now I am just waiting for my diploma!

I guess I could… it started in august?!

 

[Kiki]

Looks like you still have time - just start at the beginning. I learned some useful stuff. Now I am just waiting for my diploma!

I have been slacking.
We shall call it Fall Break.

I am thinking of the next assignment now.

 

[Lovely Lettie]

I guess this is over.....

 

[Bakbuk]

@Kiki, are we going to do more? Or are we done for now?

 

[Kiki]

@Kiki, are we going to do more? Or are we done for now?

. I think I better start a new thread. I'll think it through first and then tag you all in a new thread.

 

[Bakbuk]

. I think I better start a new thread. I'll think it through first and then tag you all in a new thread.

Okay.

 

[RoyalChick]

. I think I better start a new thread. I'll think it through first and then tag you all in a new thread.

OK. I still am hoping to get a diploma!
And seriously for a minute - I had to do a spreadsheet for something the other day and I used the column sizing trick I learned here and was pleased as punch with myself. So thank you.