title: multiple criteria small function excel
body: <p>I am stuck in finding the least 10 values in excel using small function with multiple criteria and also excluding zeros.</p>
  
  <ul>
  <li>I have 4 columns, person, date, hours and weather.</li>
  <li>I want the least hours of a person considering all the dates and the weather should not be rainy.</li>
  </ul>
  
  <p>I have used this formula:</p>
  
  <pre><code>=small(if(and(person="a",hours,"&lt;&gt;0",weather,"&lt;&gt;rainy"),hours),no)
  </code></pre>
  
  <p>where no represents the the 1-5 numbers.</p>