Hi
I have the following formula that ranks bottom three values, but my formula also populates zero in bottom three values.
How do i modify to ignore zero.
=INDEX(B2:B100,MATCH(SMALL(I2:I100,ROW(INDIRECT("1:3"))),I2:I100,0)) & " - " & SMALL(I2:I100,ROW(INDIRECT("1:3")))
Please help!
Thank you in advance
I have the following formula that ranks bottom three values, but my formula also populates zero in bottom three values.
How do i modify to ignore zero.
=INDEX(B2:B100,MATCH(SMALL(I2:I100,ROW(INDIRECT("1:3"))),I2:I100,0)) & " - " & SMALL(I2:I100,ROW(INDIRECT("1:3")))
Please help!
Thank you in advance