View original (French)

Small.value different from 0

Lilou -  
Mytå Posted messages 4246 Registration date   Status Contributor Last intervention   -
Hello,

I am reaching out to know if there is a formula that would allow me to use "small.value" but that is different from 0.

Thank you in advance.

Configuration: Windows XP / Firefox 3.6.8

4 answers

  1.
    Mytå Posted messages 4246 Registration date   Status Contributor Last intervention   957
     
    Hello forum

    There is also a matrix formula (to be validated with Ctrl+Shift+Enter) 

    =SMALL(IF(A1:A20<>0;A1:A20;""),1)

    Mytå
    --
    Thank you for responding to your question, we are not robots...
    Installed versions [MsProject 2003(FR), Excel 2003-2007(FR)]
    3