Alphabetize column with formula, not filter

[HeRoseInThree]

I am trying to sort column u (u1:u84) and My co-worker hooked me up with this formula: =INDEX($U$2:$U$88,MATCH(ROWS($U$2:U3),COUNTIF($U$2:$U$88,"<="&$U$2:$U$88),0))

It works great, except it left out 2 names. I messed around with it and can't seem to get it.

Any ideas?

 

[mopp1]

Does your data start in row 1 or row 2?

row 1: =INDEX($U$1:$U$88,MATCH(ROWS($U$1:U1),COUNTIF($U$1:$U$88,"<="&$U$1:$U$88),0))
row 2: =INDEX($U$2:$U$88,MATCH(ROWS($U$2:U2),COUNTIF($U$2:$U$88,"<="&$U$2:$U$88),0))

 

[HeRoseInThree]

It starts in 1.

I tried your row 1 formula, and when I pasted it into my spreadsheet I get #N/A error. I actually have data only in 1 - 84, but it only works when I go to 88...

 

[mopp1]

Since it is an array formula you need to enter it with Ctrl-Shift-Enter not just Enter. See if that fixes it.

 

[HeRoseInThree]

Well, don't I feel silly!
THANK YOU!!!!