Forum Discussion

Asparagus's avatar
Asparagus
Brass Contributor
Oct 16, 2022
Solved

How to ignore blank cells when using the SORTBY formula

I have a SORTBY formula that spills a list from Column A into Cell C3. The list is sorted by the words' length, from smallest to largest. However there are blank cells in the list that I wish the for...
excel
  • HansVogelaar's avatar
    HansVogelaar
    Oct 16, 2022

    Asparagus 

    Yes:

     

    =LET(Filtered, FILTER(A3:A12,A3:A12<>"",""), SORTBY(Filtered,LEN(Filtered)))

Resources