title: Range sort using multiple criteria
body: <p>I have the following data in col GA and GB respectively</p>
  
  <pre><code>GA   GB
  1   strn
  2   accn
  6   thon
  8   advn
  9   estn
  14  actn
  17  cngn
  37  autn
  49  empn
  </code></pre>
  
  <p>And I use the following auto generated code to do A->Z sort with col <code>GA</code> being the key range.</p>
  
  <pre><code>   Columns("GA:GB").Select
      ActiveWorkbook.Worksheets("CSV Dump").Sort.SortFields.Clear
      ActiveWorkbook.Worksheets("CSV Dump").Sort.SortFields.Add Key:=Range("GA1"), _
          SortOn:=xlSortOnValues, Order:=xlAscending, DataOption:=xlSortNormal
      With ActiveWorkbook.Worksheets("CSV Dump").Sort
          .SetRange Range("GA1:GB9")
          .Header = xlNo
          .MatchCase = False
          .Orientation = xlTopToBottom
          .SortMethod = xlPinYin
          .Apply
      End With
  </code></pre>
  
  <p>My question if col GA has duplicate values like following:</p>
  
  <pre><code>GA   GB
  1   strn
  2   accn
  2   thon
  8   advn
  9   estn
  14  actn
  17  cngn
  37  autn
  49  empn
  </code></pre>
  
  <p>then how can I modify the code or by any other means sort the col GB from Z->A only for the range in col GA which has duplicates?</p>
  
  <blockquote>
    <p>Expected output:</p>
  </blockquote>
  
  <pre><code>GA   GB
  1   strn
  2   thon
  2   accn
  8   advn
  9   estn
  14  actn
  17  cngn
  37  autn
  49  empn
  </code></pre>