Auto Sort By Name

  • Thread starter Thread starter Brandon
  • Start date Start date
B

Brandon

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.
 
Back
Top