FORMULA HELP
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: FORMULA HELP

  1. #1
    New Member
    Join Date
    Feb 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    Hello Group,
    I am using Excel 2000 working with an existing spreadsheet trying to modify it for better use among teachers. I have the existing file here for you to download: http://connes.wcpss.net/Excel/
    I would like to know if there is a way and/or formula to have the "running records data" sheet gather information on what the teacher entered for the students show up on the "individual" sheet. At the same time I do not want it to bring up the books which have no information entered. For example, if I entered data for "Abe" and it was on books 1-2 and nothing else, I would like only Books 1-2 to show up when I enter Abe's name on the individual sheet. Does anyone have a formula for this?

    Thanks,
    Ron

  2. #2
    MrExcel MVP Aladin Akyurek's Avatar
    Join Date
    Feb 2002
    Location
    The Hague, NL
    Posts
    81,778
    Post Thanks / Like
    Mentioned
    12 Post(s)
    Tagged
    1 Thread(s)

    Default

    On 2002-03-05 12:35, rdw wrote:
    Hello Group,
    I am using Excel 2000 working with an existing spreadsheet trying to modify it for better use among teachers. I have the existing file here for you to download: http://connes.wcpss.net/Excel/
    I would like to know if there is a way and/or formula to have the "running records data" sheet gather information on what the teacher entered for the students show up on the "individual" sheet. At the same time I do not want it to bring up the books which have no information entered. For example, if I entered data for "Abe" and it was on books 1-2 and nothing else, I would like only Books 1-2 to show up when I enter Abe's name on the individual sheet. Does anyone have a formula for this?

    Thanks,
    Ron
    Ron,

    Care to tell, given the published WB, on which books there is info for Abe and Jessica? It's unclear (to me) from "running records data" which book is the latest for Abe and Jessica.

    Aladin

  3. #3
    New Member
    Join Date
    Feb 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Abe's most recent book is Fortune's Friend(Book level 31-32)(He is basically done being tested) and Katherine's most recent book level is Nick's Glasses (Book level 7-8). Sorry for any confusion. Can you think of a formula for this?

  4. #4
    New Member
    Join Date
    Feb 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Hello group,
    Does Excel 2000 have a feature that generates a report with a "most recent date"
    that will allow the teacher to see when she has entered the data? For example, I would
    like to have another sheet that includes the information from the "data sheet" that will
    see data that was entered from July 1, 2001 - June 30, 2002 and you can select the date
    or show all records. If you know of a formula that allows this, please let me know.

    Thanks,
    Ron

  5. #5
    New Member
    Join Date
    Feb 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Group,

    Hopefully, this will clear things up a bit. I will have the end user enter the date of when they actually took the assessment so there will be a cell with the date in it. I am not even sure if this can be done with Excel 2000, but thought that if anyone knows of a solution, it would be helpful to ask.

    Thanks,
    Ron

  6. #6
    New Member
    Join Date
    Feb 2002
    Posts
    6
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    Hello,
    I am using Excel 2000 on Windows 98 working with an existing spreadsheet trying to modify it for better use among teachers. I have the existing file here for you to download: http://connes.wcpss.net/Excel/
    I would like to know if there is a way and/or formula to have the "running records data" sheet gather information on what the teacher entered for the students show up on the "individual" sheet. At the same time I do not want it to bring up the books which have no information entered or old data. For example, if I entered data for "Abe" and it was on books 31-32 (and levels 1-2 & 3-4 from a earlier date in the school year), I would like only Books 31-32 to show up when I enter Abe's name on the individual sheet. Abe's most recent book is Fortune's Friend(Book level 31-32)(He is basically done being tested) and Katherine's most recent book level is Nick's Glasses (Book level 7-8). Of course, we would do this type of sorting throughout the year to see the progress of the class and to create groups to do instruction on the students instructional level. I will have the end-user enter the date of when they actually took the assessment so there will be a cell with the date in it. We could do a sort on the "most recent date" with a formula or use VBA to accomplish this. Can you think of a formula Or a solution for this problem?

    Thanks,
    Ron

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com