LinkBack URL
About LinkBacks
I have a list of text names that are unordered alphabetically, the list also contains blanks, I need a formula that will sort the list alphabetically and discard the blanks.
Many thanks in advance
J
I have a list of text names that are unordered alphabetically, the list also contains blanks, I need a formula that will sort the list alphabetically and discard the blanks.
Many thanks in advance
J
Add a Helper column with this formula.
=IF(A1="",2,1)
Sort by Helper column then by column A
Regards
Special-K
Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.
Is there a formula that can produce this list without using the sort function on excel?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks