Im looking for a way to SORT the results of INDEX if there is a blank cell it should put the blank either first or last.

=IFERROR(SORT(INDEX(EQUIPMENT!$D$10:$D$900,MATCH(0,COUNTIF($A$134:A134,EQUIPMENT!$D$10:$D$900),0))),"")

The above code gives the result as the screenshot attached.

CodePudding user response：

As per my comment:

=LET(ζ,EQUIPMENT!$D$10:$D$900,SORT(UNIQUE(FILTER(ζ,ζ<>""))))