Find non zero values in a row by using formula

[Tariq123]

Today at 4:19 PM
Hi
Hope this find you in good health. I need help in excel. If a row have different value including zero values. Then how can I get first non zero value, Second non zero and third non zero and so on.
For example
A row have value in its different cells like this
0 3 0 4 0 0 2 0 5

1st non zero value 3
2nd non zero 4
3rd non zero 2
4th non zero 5
Which one formula can be used to get result like this?

 

[Fluff]

Duplicate to: Value from row

In future, please do not post the same question multiple times. Per Forum Rules (#12), posts of a duplicate nature will be locked or deleted.

In relation to your question here, I have closed this thread so please continue in the linked thread.