I've got a column "I" where I have pulled all the sheet names in the workbook. I am now trying to alphabetize the results in column "K". I have a formula that works beautifully, but it lists all the blank cells at the bottom of column "I" at the top of column "K". I need either a way to change the formula in column I to retrieve the sheet names in alphabetical order, or have the formula in column "K" sort while removing blanks.
Any help or suggestions would be greatly appreciated.
I've attached a reduced version of the file below.
Here is the formula in column "I":
Here is the formula in column "K":
Sort nio blanks.jpg
Bookmarks