marco melli
Level 1 (0 points)

Q: how to order data in more order criteria?

hi, may i know how to order data with more criteria? In before ios7 version there was an appeal icon where you could choose em, now i couldn't found enithing.

tanks

marco

Posted on Dec 4, 2013 8:35 AM

Close
marco melli

Q: how to order data in more order criteria?

  • All replies
  • Helpful answers

  • by Wayne Contello,

    Wayne Contello Wayne Contello Dec 4, 2013 8:37 AM in response to marco melli
    Level 6 (19,416 points)
    iWork
    Dec 4, 2013 8:37 AM in response to marco melli

    sorting functonality has been reduced in the latest version of Numbers.  Apple maybe adding this back in.  Here is a list of items they will be addressing soon:

    http://support.apple.com/kb/HT6049?viewlocale=en_US&locale=en_US

  • by SGIII,

    SGIII SGIII Dec 4, 2013 10:50 AM in response to marco melli
    Level 6 (10,796 points)
    Mac OS X
    Dec 4, 2013 10:50 AM in response to marco melli

    Hi Marco,

     

    The new Numbers can sort just as well as the old Numbers. No functionality has been lost. But the user interface for multi-column sort is missing in Numbers 3.0. It is still easy to do multi-column sort in Numbers 3.0, though.

     

    Say you have the following:

    Screen Shot 2013-12-04 at 1.41.54 PM.png

     

    And say you want a sort it first by column A and within A by C and within C by B.

     

    Just do one-column sorts in the reverse order.

     

    First sort by B:

    Screen Shot 2013-12-04 at 1.43.31 PM.png

     

    Then sort by column C and finally by A, giving this:

     

    Screen Shot 2013-12-04 at 1.44.30 PM.png

     

    This looks slightly different in iOS but is exactly the same procedure.

     

    And if you are going to do this particular sort a lot and want to save it so it is still available when you next open your document, just add a column D with the formula =A&C&B and then just sort on column D.

     

    SG