+ Reply to Thread
Results 1 to 5 of 5

lesson grades (from oldest date to newest date)

  1. #1
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    lesson grades (from oldest date to newest date)

    Hello my friends,

    example file: http://s3.dosya.tc/server15/kOIeI1/d...rade.xlsx.html

    i want to evaluate data for each lesson grades, which is higher than 80 ( + ) , less than 80 ( - )
    how can i produce from this data, a summary like this:

    physics : + - - + - + - ( oldest -----> newest date)
    maths : - - - + + -
    history : + + - + + - -

  2. #2
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: lesson grades (from oldest date to newest date)

    Please see attached
    date-lesson-grade.xlsx
    This can be done without helper column but this way more visible what's going on
    If you are http://www.excelforum.com/image.php?type=sigpic&userid=125481&dateline=1392355029happy with the results, please add to the contributor's
    reputation by clicking the reputation icon (star icon).




    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved.
    To undo, select Thread Tools-> Mark thread as Unsolved.
    http://www.excelaris.co.uk

  3. #3
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: lesson grades (from oldest date to newest date)

    what for you use $ symbol in front of Cell names? What is its function?

  4. #4
    Forum Expert RobertMika's Avatar
    Join Date
    06-22-2009
    Location
    Haverhill, UK
    MS-Off Ver
    Excel 2003-13
    Posts
    1,530

    Re: lesson grades (from oldest date to newest date)

    Before letter to lock column, before number to lock row.

  5. #5
    Forum Contributor aaaaa34's Avatar
    Join Date
    12-25-2013
    Location
    Istanbul
    MS-Off Ver
    Windows 10, MS Office 2013
    Posts
    375

    Re: lesson grades (from oldest date to newest date)

    Thanks a lot for ur support my friend.

    Do u know how i can mark this post as [SOLVED] ?
    Last edited by aaaaa34; 02-04-2014 at 08:49 AM.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] vba code to find Duplicate Values and Newest date(Max) date in the Corresponding Column(ce
    By Pradu in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-10-2013, 05:20 AM
  2. sorting a selected range by date, oldest to newest
    By zed commander in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-19-2012, 12:40 PM
  3. Top ten oldest and top ten newest
    By jhiltabidel in forum Excel General
    Replies: 11
    Last Post: 07-08-2011, 04:59 PM
  4. oldest to newest
    By Hidai in forum Excel General
    Replies: 5
    Last Post: 01-10-2011, 12:14 PM
  5. Lookup Adjacent Cell Values based on Newest and Oldest Date
    By nevi in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-09-2008, 02:27 PM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1