Search results

Dear All, I need a conditional formula for the following problem. In a Range B5:T500 , I need a conditional formula that highlights min of ( d6,H6,L6,P6,T6) similarly for other rows for above condition. I am doing for individual rows, please assit me . Thank you.

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

Hi , 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 all, 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