Returning the non-zero value in a given range of numbers and text

Hello,
I would appreciate a little help.

I have a range of cells, say A1-A6. The cells will give either 0 or a specific value (the value can be a number or text, depending on the cell) and only one of the A1-A6 will have a non-zero value. I simply want to return that one non-zero value. Since the value I want to display may not be a number I having some issues.

Ex.

0
0
0
1/0
0
0

I would want to return "1/0".

Thanks for any help,

Try this array formula

Please Login or Register  to view this content.

Confirm with Ctrl+Shift+Enter