title: Ignore blank cells in dynamic named range
body: <p>I have list with blanks and I cannot get the ever-so-popular dynamically named range formula to work:</p>
  
  <pre><code>=OFFSET(Tasks!$G$2,0,0,MATCH("*",Tasks!$G$2:$G$22,-1),1)
  </code></pre>
  
  <p>The data validation list I use it for is still showing all the blanks!</p>
  
  <p>Please help and advise!</p>
  
  <p>Many thanks</p>