E—GUAC Poll

[MACCanadianCoop]

Good enough.

Kathy and I are having a competition to see who is going to become a master of both first.

I need helpers.
She has one already.

I can help ya

 

[casportpony]

@Kiki & @MACCanadianCoop, I got one for you! In the Participant tab, write a formula that creates a list of the unique members in the Entries tab and sorts it alphabetically.
https://docs.google.com/spreadsheets/d/1D1qhOY4RM2pFLh9FolJOMfEk_etZM009p0CZJi7noUc/edit#gid=0

 

[MACCanadianCoop]

@Kiki & @MACCanadianCoop, I got one for you! In the Participant tab, write a formula that creates a list of the unique members in the Entries tab and sorts it alphabetically.
https://docs.google.com/spreadsheets/d/1D1qhOY4RM2pFLh9FolJOMfEk_etZM009p0CZJi7noUc/edit#gid=0
View attachment 3218877
View attachment 3218878

*is this something you want to happen automatically every time you update the sheet?
*are you looking to have the list pared down to just one instance of each unique user (as opposed to the current multiple)?

I know how to do these things in excel, but I'm not sure if sheets has the capability

 

[casportpony]

*is this something you want to happen automatically every time you update the sheet?

Yes

*are you looking to have the list pared down to just one instance of each unique user (as opposed to the current multiple)?

Yes

 

[Kiki]

I wouldn't call myself an expert, but I'm definitely better than ok

 

[Kiki]

@Kiki & @MACCanadianCoop, I got one for you! In the Participant tab, write a formula that creates a list of the unique members in the Entries tab and sorts it alphabetically.
https://docs.google.com/spreadsheets/d/1D1qhOY4RM2pFLh9FolJOMfEk_etZM009p0CZJi7noUc/edit#gid=0
View attachment 3218877
View attachment 3218878

Hold up boss lady....it's bed time.

 

[MACCanadianCoop]

No pressure, right?

 

[Artichoke Lover]

I can operate google sheets well enough to judge competitions and hide my column. That’s about it.

 

[Kiki]

I can operate google sheets well enough to judge competitions and hide my column. That’s about it.

Would you like to learn a few more things?

 

[Artichoke Lover]

Would you like to learn a few more things?

I’d be willing to try!