Results 1 to 4 of 4
  1. #1

    Member Since
    Apr 12, 2008
    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?"



  2. #2

    Member Since
    May 20, 2004
    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

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

  4. #4

    Sawday's Avatar
    Member Since
    Nov 19, 2006
    York, UK
    iMac: 24" Aluminium, 2.8 GHz, 4Gb RAM. iPad2, iPad mini2, 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).
    Experience teaches you to recognise a mistake when you make it again.

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 macOS - 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 macOS - 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