Index Small results sorted in numerical ascending order

[sacastiglia]

Hello All,

I am trying to figure out how to sort the results of this formula in ascending numerical order.


=IFERROR(INDEX('Man Hours'!$B$5:$B$1698,SMALL(IF(('Man Hours'!$D$5:$D$1698=316001)*('Man Hours'!$B$5:$B$1698<>316001)*('Man Hours'!$A$5:$A$1698=$G$4),ROW('Man Hours'!$A$5:$A$1698)-ROW('Man Hours'!$A$5)+1),ROWS($I$18:I18))),"")

As always, any assistance is greatly appreciated.

 

[Aladin Akyurek]

Learning opportunity: I am figuring the COUNTIF($I$18:I18,I18) part of this formula is what puts the values in order. How does this do that

That tackles with the tied values. When we have say 2 instances of 90, the IF in SMALL will deliver two corresponding row numbers. COUNTIF will say 1 for the first instance of 90, allowing SMALL to pick out first row number and feed that to INDEX. When COUNTIF says 2, SMALL will pick out the second row number corresponding to the second instance of 90 and feeding that to INDEX, completing the 90 case.

Hope this helps.