Sort text list alphabetically using a formula

[paddyyates]

Does anyone know of a formula you can use to sort a list of text
alphabetically?

I know the data/sort option but I want something that can pick up new
entries in the original data list without the use having to intervene.

Seems like a straightforward enough idea but I can't find anything.

 

[Domenic]

First, set up a dynamic range for your list of text and give it a name,
such as MyRange. Then enter the following formula in a cell, let's say
B1, and copy down:

=IF(ROWS($B$1:B1)<=COUNTA(MyRange),INDEX(MyRange,MATCH(SMALL(COUNTIF(MyRa
nge,"<"&MyRange),ROWS($B$1:B1)),COUNTIF(MyRange,"<"&MyRange),0)),"")

....confirmed with CONTROL+SHIFT+ENTER, not just ENTER. Post back if you
need help creating a dynamic range.

Hope this helps!

 

[paddyyates]

That works, thanks. It seems the answer wasn't that straightforward!