Forum Discussion

SimonMS's avatar
SimonMS
Occasional Reader
Nov 24, 2025

Excel bug Data sorting largest to smallest

I have some problems by sorting data in excel. First sorting by column M Largest to Smallest, than by column L also Largest to Smallest. In one case sorting is not successfully (Marked font color R...
excel
IlirU's avatar
IlirU
Brass Contributor
Nov 25, 2025

Try this formula:

 

=SORT(IF(B5:M62 = "", "", B5:M62), {12,11}, {-1,-1})

 

Hope this helps.

  • SergeiBaklan's avatar
    SergeiBaklan
    Diamond Contributor
    Nov 25, 2025

    It gives exactly the same (i.e. wrong) result

    plus doesn't sort in place.

    • IlirU's avatar
      IlirU
      Brass Contributor
      Nov 25, 2025

       

      I don't know why you get those results. With my formula, I get these results like in the image.

       

      I have apply my formula in cell O5.

       

       

Resources