All the values in a row where cell value not equal to zero

[Raghava@rock]

Hi Team,

Need a formula to get all the cell values which are not equal to zero in an range of cells.
A B C D E Required Result
Row1 0 1 0 1 1 Need Value as B,D,E
Row2 0 0 1 0 1 Need Value as C,E
Row3 1 0 0 1 0 Need Value as A,D
Row4 0 1 1 0 1
Need Value as B,C,E

 

[Khalid NGO]

Hi,
Can you post your question in xls file?

 

[Khalid NGO]

I have revisit your thread and came up with the following:

Please see the attached:

 

[Somendra Misra]

Hi,

See the file, which uses UDF to get the required result.

Regards,