Formula in sorting alphabetically

[felixpanganiban]

Do we have formula automatically sorting alphabetically? Any suggestion?

Sample:

Ana
Mike
Betty
Carl
Babes
Zen

[K m]

Try DATA/SORT on your list

[felixpanganiban]

I need one sheet summary.

Sample,
Sheet 1 is my database then sheet 2 summary with formula and automatic arrange alphabetically

[Moo the Dog]

Try this - you'll need the sort helper row though (you can hide that row if necessary)

- Vince

[K m]

I don't understand