How to re-write the formula to ignore Zero

[andyka]

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

 

[andyka]

Thank you managed to workout.

 

[Fluff]

Good to hear you got the solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.

 

[andyka]

=INDEX(B2:B100,MATCH(SMALL(I2:I100,ROW(INDIRECT("1:3"))),I2:I100,<>0)) & " - " & SMALL(I2:I100,ROW(INDIRECT("1:3")))

Solution: I added <> before Zero and it worked