Hi,

I have a table of contact list in which person's employer name is entered.
What i want is to use that employer name (from input column) and arrange
these firms name in alphabetical order so that i can apply data validation on
it.

My second question is in relation to it. To apply data validation, I need
every employer name once. So how can I filter or extract the employer name
(as there are more than one people working for same company) from that
column, and that extracted column will be arranged alphabetically to reach
the company easily.

Kind regards,
Zubair