sacastiglia
New Member
- Joined
- Jul 29, 2014
- Messages
- 23
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.
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.