Hi, I'll take a look at that, thanks Alex. That's the trouble with Excel; there's hundreds to play with, and I don't have the time to play with them all <smiles>.
-- Chris Hallsworth Please visit my blog at http://chrishallsworth.wordpress.com You wrote: Chris, Surely there must be an excel function which will give you the number of days in a given month. I haven't used it for a good while, but as I recall there are an awful lot of date related functions in excel. Cheers Alex -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Sent: 06 July 2008 12:47 To: [email protected] Subject: [Blind-Computing] More Help with Assignment Hi all, first I'd like to say thank you very much for the help with my previous assignment help. I have successfully completed the yearly_model worksheet. However I need more help please, this time involving the monthly_model worksheet. Basically on the top row, from B1-M1, I have the months of the year. Although I have an idea what to do, for example find out the number of days of the data, I can't think what would be the easiest way to do it. Using Excel's find function, I was able to get the results I wanted, but for my memory I can't remember the areas it selected. I'm asked to use appropriate formulae, so I couldn't just type the number of days as simple numbers. Does anyone have any easier way of accomplishing this, for example maybe sorting the date column in the share_prices worksheet to month order? Thank you very much once again for the help in advance, and I look forward to hearing from you. -- Chris Hallsworth Please visit my blog at http://chrishallsworth.wordpress.com Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected]/ To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/BlindComputing.php If you wish to join the JAWS Users List send a blank email to the following address: [EMAIL PROTECTED] Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected]/ To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/BlindComputing.php If you wish to join the JAWS Users List send a blank email to the following address: [EMAIL PROTECTED] Visit the JAWS Users List home page at: http://www.jaws-users.com Visit the Blind Computing home page at: http://www.blind-computing.com Address for the list archives: http://www.mail-archive.com/[email protected]/ To post to this group, send email to [email protected] To unsubscribe from this group, send an email to [EMAIL PROTECTED] For help from Mailman with your account Put the word help in the subject or body of a blank message to: [EMAIL PROTECTED] Use the following form in order to contact the management team http://www.jaws-users.com/BlindComputing.php If you wish to join the JAWS Users List send a blank email to the following address: [EMAIL PROTECTED]
