Results 1 to 4 of 4
  1. #1
    Numbers - sort columns by month

    Member Since
    Apr 12, 2008
    Posts
    403
    Numbers - sort columns by month
    Hi all,
    Anyone have any experience sorting iWork Numbers columns by month. I have a column set up using the pop-up menu to define all the months. So if I change a month for a particular cell, how do I re-sort it by month order?
    All it seems to do, is sort the months alphabetically.

    Is it worth getting "The Missing Manual?"

    Thanks

    Neil

  2. #2
    Numbers - sort columns by month

    Member Since
    May 20, 2004
    Posts
    243
    Specs:
    iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB
    Howdy. That is true in most spreadsheets (unless something specific is added). I have always found it easier to use the number for the month, then it will always sort correctly.
    Mellel 3, NWP 2, Scrivener 2.3.1, Tinderbox 5.11.2
    LibreOffice 3.6, Accordance 10.0, Adobe CS4, DTP 2.4.3
    OS X 10.8.2

  3. #3
    Numbers - sort columns by month

    Member Since
    Apr 12, 2008
    Posts
    403
    Reason I asked, is that I was sure I was able to do it recently, but forgot how.

  4. #4
    Numbers - sort columns by month
    Sawday's Avatar
    Member Since
    Nov 19, 2006
    Location
    York, UK
    Posts
    1,122
    Specs:
    24" Aluminium, 2.8 GHz, 4Gb RAM. iPad2, iPhone5s
    Create another column to hold month number and sort on that? You could set the number using a VLOOKUP table (that is in Excel terminology - not sure what Numbers formula is).
    Happiness is not getting what you want, but wanting what you get.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Numbers will not sort
    By Cover3 in forum OS X - Apps and Games
    Replies: 0
    Last Post: 12-05-2014, 07:58 PM
  2. Replies: 1
    Last Post: 11-14-2013, 09:52 AM
  3. New numbers sort
    By wvtrammell in forum OS X - Operating System
    Replies: 2
    Last Post: 10-27-2013, 08:04 AM
  4. Replies: 0
    Last Post: 08-01-2010, 07:46 AM
  5. auto numbering columns in Numbers
    By lesnorvell in forum Switcher Hangout
    Replies: 0
    Last Post: 08-18-2009, 05:25 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •