Excel help 3rd non blank cell from right in row

[bmaness]

Hello Forum,
I am looking for a formula to pull the 3rd non blank cell from right in row. Example attached with highlighted cells I am looking to pull out with a formula.
Thanks!

[Bo_Ry]

Please try at L2

=INDEX(A2:K2,LARGE(INDEX(COLUMN(A2:K2)*(A2:K2>0),),3))

[Pepe Le Mokko]

Try

Please Login or Register  to view this content.

and pull down

[bmaness]

Thank you - super simple and it works.

[Pepe Le Mokko]

You're welcome, but only if all contiguous cells are not empty !