Looking Up Nth Non-Zero Value

[jayhawk123]

How do I look up the nth non-zero value in a row? i.e. the 1st, 4th, 7th, 10th, etc.

My range of values is $K5:$AK5. I want to copy this formula down for 500+ rows. I am entering the formula in column DW, in case that's helpful to know.

Would appreciate any help!

Thank you

[daddylonglegs]

Try this formula for the 4th

=IFERROR(INDEX($K5:$AK5,SMALL(IF($K5:$AK5<>0,COLUMN($K5:$AK5)-COLUMN($K5)+1),4)),"No match")

confirmed with CTRL+SHIFT+ENTER

[jayhawk123]

Works brilliantly. Thank you

[sachapedro]

I LOVE YOU!!

You just saved me Thank you for this answer!