Forum Discussion

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
Oct 16, 2022
Asparagus

Yes:

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

HansVogelaar

MVP

Oct 16, 2022

Asparagus

Yes:

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

Asparagus

Brass Contributor

Oct 16, 2022

Amazing!
Excel is as brilliant as those with the knowledge on how to use it. You are brilliant. Thank you so much, this is just what I need.

cheers