0

I have a sheet that has a column of names. I want to have another sheet that copies all of the entries from this column in sheet 1 and alphabetizes them automatically as I add new entries into sheet 1. How can I do this?

-1

I figured it out. I used

=ARRAYFORMULA(SORT(Sheet1!A2:A))
1
  • @Rubén sort(A2:A) works fine, even if the documentation suggests otherwise.
    – user79865
    Apr 4 '16 at 20:46

This site is temporarily in read only mode and not accepting new answers.

Not the answer you're looking for? Browse other questions tagged .