title: Excel sort list after string occurence
body: <p>I have a sheet in Excel 2013 with the following rows:</p>
  
  <pre><code>A113F01
  A234D01
  A233F01
  A413G02
  A412C01
  A413D01
  A114G01
  A116D02
  A333F02
  A342G01
  A233F03
  A233G04
  </code></pre>
  
  <p>Is there a way to sort these rows, first after the number of occurrences of the 4 first characters in each row, then in ascending order so that the list looks like this:</p>
  
  <pre><code>A113D01
  A113F01
  A233F03
  A233G04
  A413D01
  A413G02
  A114G01
  A116D02
  etc....
  </code></pre>