Hi, I actually want the total number of days for that year. (No, it's not 365, but I want the number of days for that year according to the criteria). Hope that helps.
-- Chris Hallsworth Please visit my blog at http://chrishallsworth.wordpress.com You wrote: Ok, that answers one question, but what is it that you are going to put in the cell on the second sheet? You mentioned something about 1, 2, or 3. What determines what number you want put into that cell? -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Sent: Saturday, July 05, 2008 2:55 PM To: Annette Carr Subject: Re: [Blind-Computing] Help with Assignment Hi, it's in one cell only. Hope this helps. -- Chris Hallsworth Please visit my blog at http://chrishallsworth.wordpress.com You wrote: What are the conditions that you want to enter the values 1, 2, 3, etc. when you find 2003 ? Will 2003 be found only in 1 cell, or in a range of cells in this other worksheet in the same workbook? Annette -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chris Sent: Saturday, July 05, 2008 12:38 PM To: [email protected] Subject: [Blind-Computing] Help with Assignment Hi all, I've just started re-taking my assignments for my second year at university, as I failed to complete them. I'm currently in the middle of an Excel spreadsheet I have to complete, and I have a question, which I'd like you to answer please. I'm using Microsoft Excel 2003 for this. I have at least three worksheets, and I'd like to know the following please. Can I tell Excel to look up, in the date column of the share_prices worksheet, evaluate if the date falls within the year 2003, and tell Excel to insert numbers like 1, 2, 3, etc, in the yearly_models worksheet. Note I stress that this is in the same workbook. I find the help a little hard to understand, but that's probably because I'd like to get this done out the way as I have lots more to do before deadline day, which is Friday August 29 at 12:00PM. Therefore I thank you in advance for the help regarding this, and I'm very sorry for the long post, but that was the only way I could explain it to you without attaching the spreadsheet and sending it to you. Of course if anyone wants the spreadsheet itself, please write to me off list and I'll be more than happy to do it, as the more help I receive the more likely I'll achieve a good mark for this assignment. Thanks once again for the help, and I look forward to hearing from -- 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] 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]
