This works great until A1:A3 has a zero involved, then it returns all zero's. Pretty sure it has to do with *(multiplication) but would like to stay with sumproduct if possible.
1] A5 =SMALL(A1:F3,1)
2] In B5, formula copied across right until blank :
=IFERROR(SMALL($A$1:$F$3,SUMPRODUCT(($A$1:$F$3>0)*($A$1:$F$3<=A5))+1),"")
<tbody>
</tbody>Much appreciated
1] A5 =SMALL(A1:F3,1)
2] In B5, formula copied across right until blank :
=IFERROR(SMALL($A$1:$F$3,SUMPRODUCT(($A$1:$F$3>0)*($A$1:$F$3<=A5))+1),"")
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |
1 | 28 | 48 | 58 | 20 | 00 | 50 | ||||||||
2 | 85 | 05 | ||||||||||||
3 | 85 | 05 | 15 | 65 | 75 | 95 | ||||||||
4 | ||||||||||||||
5 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | 00 | |
6 |
<tbody>
</tbody>