I have a column where each row has text or is blank. I need a function that can sort those values into a 2nd column in ascending order of text. I thought Small(array,k) would work but it doesn’t for text. And I can’t find any function or combination of functions to do that. I need to do this without a user having to invoke the Excel sort.
So if a column has
ZZ
AA
blank
FF
DD
blank
blank
CC
I would want to end up with
blank
blank
blank
AA
CC
DD
FF
ZZ
I have a combination of functions that will let me pull just the text from that column into a 3rd column to end up with only value sorted text
Thanks for any help/suggestions
Bookmarks