Forum Discussion

null null's avatar
null null
Copper Contributor
Jan 20, 2018

Excel Sorting Issue

Hi 

 

I have a column of numerical data that I want to sort from the Largest to the Smallest, however, I do not have the option of sorting from Largest to Smallest, instead, it only has the option of sorting A to Z, or Z to A.

 

This an abstract of my data, I am trying to sort the "Total" column.

 

 

Then I tried to custom sort, and they did not have the sort "Largest to Smallest" option as well. Hence, I went to manually enter a new list and typed "Largest to Smallest" then click sort. But my data instead sort from the Smallest to Largest... 

 

How can I solve this?

excel
  • JKPieterse's avatar
    JKPieterse
    Silver Contributor
    Jan 22, 2018
    I suspect your numbers are not considered to be numbers but are seen as text.
    Assuming these are NOT formulas:
    Insert a blank workbook (control+n key), enter a 1 in a cell and hit control+c
    Now go to your other workbook, select the "numbers" and hit control+alt+v to open the paste special dialog. Choose "Values" and "Multiply" and press OK.
    • null null's avatar
      null null
      Copper Contributor
      Jan 24, 2018

      Hi Jan Karel, thank you for your reply.

       

      However, these are formulas...  and the formula is as such: =IF(C4<>"",SUM(E4:M4),"")

      • JKPieterse's avatar
        JKPieterse
        Silver Contributor
        Jan 24, 2018
        In that case they should add up. Is calc set to automatic?

Resources