Basavaraj K H
Member
Hi Team
Please find attachment for your reference, in that I need formula 1st 2nd & 3rd Smallest value in range including zero's,
I tried by below formula
=IFERROR(INDEX($A$2:$J$2,IF(COUNTIFS(A3:J3,0)<=0,0,MATCH(SMALL(A3:J3,1),A3:J3,0))),"")
it's working for 1st only, I need 2nd & 3rd Smallest value in particular range including zero's
Thank you in advance
K H Basavaraj
Please find attachment for your reference, in that I need formula 1st 2nd & 3rd Smallest value in range including zero's,
I tried by below formula
=IFERROR(INDEX($A$2:$J$2,IF(COUNTIFS(A3:J3,0)<=0,0,MATCH(SMALL(A3:J3,1),A3:J3,0))),"")
it's working for 1st only, I need 2nd & 3rd Smallest value in particular range including zero's
Thank you in advance
K H Basavaraj
Attachments

11.1 KB Views: 5