#### vmohan1978

##### Member

I have values in a2,b2,c2,d2,e2,f2,g2,h2,i2,j2,k2 I have to find the lowest non zero values in ( a2,c2,f2,i2,k2)

Ex: 2,5,6,8,9,0,45,78,58,98,88, lower of (2,6,0,58,88) is 2.

Is there any formula is there please do the needful

- Thread starter vmohan1978
- Start date

I have values in a2,b2,c2,d2,e2,f2,g2,h2,i2,j2,k2 I have to find the lowest non zero values in ( a2,c2,f2,i2,k2)

Ex: 2,5,6,8,9,0,45,78,58,98,88, lower of (2,6,0,58,88) is 2.

Is there any formula is there please do the needful

Suppose in the range "0" is not there then it has to pick the lowest of the range,

If in a range "0" is there then it has to pick lower value.

Ex

If in a Range (2,6,0,58,88)result=2

If in a Range ( 2,1,5,6,8) result=1 .

I need a formula which satisfies both the condition.

Dear Hui,

Thank you very very much, sparing time to solve the problem. It saved lot of time of mine.

Thank you very very much, sparing time to solve the problem. It saved lot of time of mine.