Finding nth non-zero in a row

[krweaver]

I am currently using this array formula: =INDEX(M17:O17,SMALL(IF(M17:O17<>0,COLUMN(M17:O17)-COLUMN(M17)+1),U17))

M17 to O17 contains 0, 5, 5, respectively. U17 contains a 3

So, I thought I was finding the 3rd smallest which would be a 5 (which is also the 2nd smallest). However, it's an error.
The formula works for finding the 2nd smallest (a 5) when U17 is a 2.

How do I tweak this when the 2nd and 3rd, like this case, are the same? Or did I overlook something here (maybe)?

[José Augusto]

Hi

I don't know if I'm thinking well. With the data you send, {0, 5, 5}, the first smallest nonzero is the first 5 and the second the last 5. There are no third smallest nonzero.

Can you explain better, please?

[Richard Buttrey]

What's wrong with

Please Login or Register  to view this content.

[José Augusto]

What's wrong with

Please Login or Register  to view this content.

Topic title says non-zero
I suppose @krweaver wants

Please Login or Register  to view this content.

[krweaver]

Thank you...have resolved it. Have a different issue and will post separately shortly.