title: How to Sort Excel Column S.T. Rows w/ Null/Empty Column Cell Go On Top?
body: <p>I have several rows that have data and 'flags' that are raised adjacent to the data when a macro is run.
  For example:<br>
  <strong><em>First Name</em></strong> | <strong><em>Last Name</em></strong> |     <strong><em>Flag</em></strong>
  <br></p>
  
  <pre><code>John  | Smith  | Needs a Bath 
  Cindy | LuWho  | 
  Bob   | Loblaw | Needs a Bath
  </code></pre>
  
  <p><strong>Goal:</strong><br>
  I want the rows w/o flags (ie where column C == NULL/Empty string) to be sorted to the top and then sort by column B by A->Z to get this:</p>
  
  <blockquote>
    <p>Cindy | LuWho | <br> Bob | Loblaw | Needs a Bath <br> John | Smith |
    Needs a Bath <br></p>
  </blockquote>
  
  <p><strong>What I've Tried:</strong><br>
  Using Excel 2007's 'Sort', I've done Sort By (Column C), Sort On (Values) Sort By (A to Z) and (Z to A). Both A to Z and Z to A result in the flagged rows on top, not the bottom.</p>
  
  <p>Before:<img src="https://i.stack.imgur.com/GhqDi.png" alt="enter image description here">
  After:<br><img src="https://i.stack.imgur.com/6ZRRb.png" alt="enter image description here"></p>
  
  <p>I ultimately want the code, but I'm currently trying to figure out how to do it by hand so I can then get the code through Excel's 'Record Macro'.</p>