soldier2gud4me
Reputation: 79
How to Sort if Index shows blank value in excel
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.
Upvotes: 0
Views: 83
Answers (1)
Jos Woolley
Reputation: 9052
As per my comment:
=LET(ζ,EQUIPMENT!$D$10:$D$900,SORT(UNIQUE(FILTER(ζ,ζ<>""))))
Upvotes: 1
Related Questions
- Excel Index - how to return a blank if the cells show 0
- VBA: Sort with blank / no / empty value in first position / at beginning. Error 1004 Application-defined or object-defined error
- In Excel, by Sorting the blank character should come first
- Excel: How to add an index that ignores empty cells
- Excel - Ignore blanks in descending sort
- Excel sort 2 column with missing elements
- Excel VBA Sort Range with Blank AND Empty Values at Bottom of Range
- Sort Order formula to alphabetise in Excel
- Sort table taking into consideration blank cells
- How to Sort Excel Column S.T. Rows w/ Null/Empty Column Cell Go On Top?