E—GUAC Poll

[samanthaoverton]

Ahh this all gives me a headache..I felt inept the other day with Google sheets app.. I loathe failure. I was like oooh it loaded..ooh I got permission..ooh I can't clicky to tipey ratings on photo contest

 

[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

Help me!

 

[Kiki]

I'm Not going to bed until I get it.
Do not make me do something else after this because I need to go to bed soon.

 

[Kiki]

 

[samanthaoverton]

This is not conducive to sleep...

 

[Kiki]

This is not conducive to sleep...

Kathy started it.

 

[MACCanadianCoop]

https://trumpexcel.com/sort-data-in-alphabetical-order-formula/

 

[azurbanclucker]

I’d be willing to try!

 

[Kiki]

https://trumpexcel.com/sort-data-in-alphabetical-order-formula/

Do it on the sheet for me please.
I have two lists but I need one. I can't read all this crap tonight but I need one correct list before I

 

[MACCanadianCoop]

Do it on the sheet for me please.
I have two lists but I need one. I can't read all this crap tonight but I need one correct list before I

I don't have edit access. This is the formula, I think. I've never tried this particular thing before.

=INDEX($A$4:$A$200,MATCH(ROWS($A$4:A4),COUNTIF($A$4:$A$200,"<="&$A$4:$A$200),0))