title: Merge two lists in Excel in ascending or descending order
body: <p>I have two independent lists in Excel. I need to combine them into one list and have that list sorted either ascending or descending order.</p>
  
  <p>For example how to merge these two lists (Named ranges <code>List1</code> and <code>List2</code> in Excel)</p>
  
  <pre><code>List1      List2
  AA         BB
  DD         EE
  FF         GG
  KK
  </code></pre>
  
  <p>into one list</p>
  
  <pre><code>AA
  BB
  DD
  EE
  FF
  GG
  KK
  </code></pre>
  
  <p>I managed to merge the lists but without ascending or descending sorting with the following formula:</p>
  
  <pre><code>=IFERROR(INDEX(List1, ROWS(AH4:$AH$4)), IFERROR(INDEX(List2, ROWS(AH4:$AH$4)-ROWS(List1)), ""))
  </code></pre>
  
  <p>and the result looking like this</p>
  
  <p><img src="https://i.stack.imgur.com/jVHOg.png" alt="enter image description here"></p>
  
  <p><strong>Can the sorted merged list be achieved using formulas only (no VBA)?</strong></p>