Path: utzoo!utgpu!news-server.csri.toronto.edu!rutgers!cs.utexas.edu!swrinde!zaphod.mps.ohio-state.edu!sdd.hp.com!spool.mu.edu!uunet!shelby!portia.stanford.edu!jessica.stanford.edu!buc From: buc@jessica.stanford.edu (Robert Richards) Newsgroups: comp.sys.mac.misc Subject: Excel and how to extract data based on the month Message-ID: <1991Feb4.072727.29672@portia.Stanford.EDU> Date: 4 Feb 91 07:27:27 GMT Sender: news@portia.Stanford.EDU (Mr News) Distribution: usa Organization: Stanford University Lines: 15 In a checkbook type spreadsheet is there an example out there or a simple method to extract information depending on the month? That is, one has a spreadsheat with a column of dates, a column of check numbers, bla bla bla, and a column of catagories. I would like to have a section where the expenses by category is broken down monthly. I have the manuals, but can not find a straight-forward technique. Any pointers or assistance is appreciated. =============================================================================== Rob Richards Supercomputer & Workstation Support Staff AIR Stanford University ===============================================================================