The Data
A B C
1 50 80 0
2 0 0 100
3 75 0 90
4 60 70 80
5 45 50 0

The three columns in each row can have 1, 2 or 3 non-zero numbers (but will
always have at least one). The numbers/zeros can be in any column. I need
column D to show the number if there is only one non-zero, the lowest if
there are two, and the middle number if there are three non zero. In the
example D1 and down would be 50, 100, 75, 70 and 45

Thanks
WAL50