Excel 2007 : Choose minimum value omitting zeros?

**zaqop4** · 07-16-2010, 06:38 AM

Hi,

Does anyone know how to change this formula so that zeros are not counted?

=MIN(18.0000000005*IF(,B2=0,B2>0),(21.9999999993*IF(,C2=0,C2>0)),(18.0000000005*IF(,D2=0,D2>0)),(8.99999999928*IF(,E2=0,E2>0)),(9.999999998*IF(,F2=0,F2>0)),(11.0000000011*IF(,G2=0,G2>0)),(29.9999999976*IF(,H2=0,H2>0)),(29.9999999976*IF(,I2=0,I2>0)))

I've tried and tried but I just cant get it to work.

Please help me.

**pike** · 07-16-2010, 07:09 AM

Hi zaqop4
Welcome to the forum

Try this
=SMALL(A1:C7,COUNTIF(A1:C7,"0")+1)

**DonkeyOte** · 07-16-2010, 07:18 AM

Perhaps you want:

Please Login or Register  to view this content.

confirmed with CTRL + SHIFT + ENTER

**zaqop4** · 07-16-2010, 07:22 AM

Thank you so much Donkey

**pike** · 07-16-2010, 07:53 AM

DO is one of the best

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save