Skip navigation

Sorting by Multiple Columns in Numbers 3.0

6140 Views 55 Replies Latest reply: Dec 8, 2013 8:50 AM by SGIII RSS
1 2 3 4 Previous Next
Olathe Mike Level 1 Level 1 (0 points)
Currently Being Moderated
Oct 23, 2013 5:56 AM

The new Numbers 3.0 update has moved some stuff around I need, and can not find. 

 

Where is "Reorganize"?  The ability to sort multiple by columns.  (e.g. Sort Ascending Column A, THEN Column B, THEN Column C)

 

 

mf

iMac, Mac OS X (10.6.8)
  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Oct 23, 2013 6:12 AM (in response to Olathe Mike)

    Mike,

     

    Multiple sort, and the entire Reorganize Panel, seem to be casualties.

     

    I guess we'll be sorting one column at a time. Remember to sort least important column (lowest order) first.

     

    Jerry

  • pbacchi Calculating status...
    Currently Being Moderated
    Oct 23, 2013 6:21 AM (in response to Jerrold Green1)

    I sure hope they fix this.  Being able to do multi column sort was a much used feature for me. 

     

    Philip

  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Oct 23, 2013 6:25 AM (in response to pbacchi)

    Phillip,

     

    Use the Feedback option in the Numbers menu to register your wishes.

     

    Jerry

  • douglasfromnewton Calculating status...
    Currently Being Moderated
    Oct 26, 2013 1:35 PM (in response to Olathe Mike)

    I am eager to switch from excel to numbers. Not being able to sort by multiple columns (defining priorities) and not being able to select and print a portion of one page is a real impediment. This is my first day using Numbers. I hope there are not more surprises.

  • Jerrold Green1 Level 7 Level 7 (28,135 points)
    Currently Being Moderated
    Oct 26, 2013 1:42 PM (in response to douglasfromnewton)

    This is probably not a good time to switch. Depends on what you are looking for, but Numbers is less powerful now that it ever was. What Numbers 3.0 offers that earlier versions didn't is cross-platform compatibility and a collaborative mode.

     

    I haven't checked out either of these new features though, so I can't comment on how well they work.

     

    Jerry

  • SGIII Level 4 Level 4 (3,290 points)
    Currently Being Moderated
    Oct 26, 2013 1:55 PM (in response to douglasfromnewton)

    Just in case you want to stick with Numbers 3 because it works on tablets, etc., the price is right, and it (we hope) will improve:

     

    There is a not-too-painful workaround for multicolumn sort, from the early days of spreadsheets.

     

    Say you have column A, B, and C and you want to sort first by A then by C then by B. Add a column D with the formula =A&C&B. Then sort by D.

     

    The multicolumn filtering (as opposed to sort) isn't bad at all, in my opinion. And single-column filtering from any cell in the body of a table is handy too.

     

    (I'm an Excel user myself and find them good at different things).

     

    SG

  • douglasfromnewton Level 1 Level 1 (0 points)
    Currently Being Moderated
    Oct 26, 2013 2:47 PM (in response to SGIII)

    Thank you very much. I think this will work until the resources are supplied to improve Numbers. And yes, I am eager to use Numbers (and Pages) for the ease of using on multiple Apple devices.

  • purple meanie Calculating status...
    Currently Being Moderated
    Oct 26, 2013 3:27 PM (in response to Jerrold Green1)

    wow, so the upgrade is misnamed.  it should be a downgrade.

  • SGIII Level 4 Level 4 (3,290 points)
    Currently Being Moderated
    Oct 26, 2013 4:58 PM (in response to purple meanie)

    More like an "outgrade".  Dragged down toward the lowest common denominator, but the lowest common denominator is greater than before. So, if you want something that works across devices and on the web, on balance you're better off than before, I think... And, of course, the price is tough to beat.

     

    SG

  • BobHallsworth Level 1 Level 1 (5 points)
    Currently Being Moderated
    Oct 28, 2013 11:07 PM (in response to douglasfromnewton)

    Not a cheap solution, but Excel on Mac and Windows, with docstogo on iOS devices, using dropbox works :-(

     

    Bob

  • Saqib Calculating status...
    Currently Being Moderated
    Oct 31, 2013 1:53 AM (in response to SGIII)

    this didn't work for me - i have item, then price, then checkbox. using the formula just gave an amalgamation of the three cells.

     

     

    totally sucky. you hear me Apple?

     

    edit: just figured out you can export to 09 format. i have done so and changed the system wide settings to use 09 first.

  • SGIII Level 4 Level 4 (3,290 points)
    Currently Being Moderated
    Oct 31, 2013 5:46 AM (in response to Saqib)

    this didn't work for me - i have item, then price, then checkbox. using the formula just gave an amalgamation of the three cells.

     

    Hi Saqib,

     

    The very idea of the workaround is to give an amalgamation, more often called "concatenation", and then just sort on the column containing the concatenated "string."

     

    As you've discovered, the =A&C&B formula only works if A,C, and B are all text. If you've got numbers in the mix then you have to pad them with leading zeros for them to sort as you want. That's easily done.

     

    Let's say C is a number and A and B are strings. You could put somethng like this in column D:

     

    =A&RIGHT("0000"&C,4)&B

     

    It's certainly not convenient to have to add a new column and put in a formula. But this is not *that* difficult as a workaround until the day multcolumn sort is added back in.

     

    SG

  • Saundra Curry Level 1 Level 1 (5 points)
    Currently Being Moderated
    Oct 31, 2013 8:28 AM (in response to SGIII)

    My husband has a NeoOffice SS file of all the books he has read, and no longer wants to pay $10 per year to upgrade NeoOffice versions. We exported that file in .csv format and opened that .csv file with Numbers 3.0. He wants to sort first by author, then by copyright date, which are columns A and B. There are over 600 rows.

     

    To follow the instructions, "Say you have column A, B, and C and you want to sort first by A then by C then by B. Add a column D with the formula =A&C&B. Then sort by D," where would we insert the formula (in our case) =A&B; does it have to go in every row of the new column we created, or can you put a formula in a header cell which would affect every row in that column?

     

    Thanks for your help! Sorry to be such a dunce...my understanding of spreadsheets is somewhat limited.

    MacBook Pro, Mac OS X (10.7.4), 2.2 GHz Core i7, 4 GB 1333 MHz DDR3
1 2 3 4 Previous Next

Actions

More Like This

  • Retrieving data ...

Bookmarked By (0)

Legend

  • This solved my question - 10 points
  • This helped me - 5 points
This site contains user submitted content, comments and opinions and is for informational purposes only. Apple disclaims any and all liability for the acts, omissions and conduct of any third parties in connection with or related to your use of the site. All postings and use of the content on this site are subject to the Apple Support Communities Terms of Use.