Numbers - sort columns by month

Joined
Apr 12, 2008
Messages
512
Reaction score
4
Points
18
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
 
Joined
May 20, 2004
Messages
243
Reaction score
12
Points
18
Your Mac's 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.
 
OP
N
Joined
Apr 12, 2008
Messages
512
Reaction score
4
Points
18
Reason I asked, is that I was sure I was able to do it recently, but forgot how.
 
Joined
Nov 19, 2006
Messages
1,782
Reaction score
81
Points
48
Location
York, UK
Your Mac's Specs
iMac: 5K 27” (2020), 3.3 GHz, 32Gb RAM. iPad2, iPad mini4, iPhone 13 Mini, Apple Watch SE
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).
 

Shop Amazon


Shop for your Apple, Mac, iPhone and other computer products on Amazon.
We are a participant in the Amazon Services LLC Associates Program, an affiliate program designed to provide a means for us to earn fees by linking to Amazon and affiliated sites.
Top