title: How to create a sub-Table by multiple conditions?
body: <p>I've a table <code>Tabelle2</code> formatted as a Table in Excel. One column <code>KW</code> contains numbers and missing values:  </p>
  
  <pre><code> KW=[1,1,5,6,7,#NV,#NV] 
  </code></pre>
  
  <p>and the other column contains text. I want a sub table with only the rows in <code>KW</code> <code>&gt;= max(KW)-1</code> and without <code>#NV</code>.  </p>
  
  <p>How to do it in Excel?</p>
  
  <p>For better understanding in R I would just do:  </p>
  
  <pre><code>SubTable=Tabelle2[Tabelle2$KW &gt;= (max(Tabelle2$KW)-1) &amp;&amp; Tabelle2$KW != "#NV";]
  </code></pre>