I am trying to sort a list of names with the use of a formula. I have a
spread sheet that has a list of hundreds of names and list will continue to
grow over time. I want to resort this list in alphabetical order each time a
new set of names are added to the list. I want to do this with a formula
instead of using the data - sort function.

My data is listed in Column A.

A
Smith John
Louis Steve
Jones Tim
Stevens Bob

With data in column A, in B1 enter:

=IF(ROWS(A$1:A1)<=COUNTA($A$1:$A$100),INDEX($A$1:$ A$100,MATCH(SMALL(IF($A$1:$A$100<"",COUNTIF($A$1: $A$100,"<"&$A$1:$A$100)),ROWS(A$1:A1)),IF($A$1:$A$ 100<"",COUNTIF($A$1:$A$100,"<"&$A$1:$A$100)),0)), "")

and copy down

1. this is an array formula that must be entered with CNTRL-SHFT-ENTER
rather than just the ENTER key.

2. adjust the $100 to be more than the maximum possible table size.
--
Gary''s Student - gsnu200835


"Brandon" wrote:

I am trying to sort a list of names with the use of a formula. I have a
spread sheet that has a list of hundreds of names and list will continue to
grow over time. I want to resort this list in alphabetical order each time a
new set of names are added to the list. I want to do this with a formula
instead of using the data - sort function.

My data is listed in Column A.

A
Smith John
Louis Steve
Jones Tim
Stevens Bob