Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    sorting grades and marks...please help me.. (excel 97)

    Hello again,

    I hope you can help me with this sorting problem..
    This thing is driving me nuts..Its about sorting the combination
    of grades and marks..In my works..first it will looks for the student
    with the highest grades..if two students (or more) have the same
    grades, it will sort it according to their marks..i've already got headache
    and flu trying to solve this..lol..plz refer to attachment..many thanks..


    ps: if someone can help me solved this thing..i really appreciate it..
    Attached Files Attached Files

  2. #2
    5 Star Lounger
    Join Date
    Dec 2000
    Location
    Reading/Swindon, Berkshire, United Kingdom
    Posts
    664
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sorting grades and marks...please help me.. (excel 97)

    The problem was in your code, with the range you selected: b14:x83 and the parameter xlguess: this was taking row 14 to be a header row so not including it in the sort.

    I changed that to b13:x83 and xlyes and it now appears to work fine.
    I could have used b14:x83 and xlno - I just chose not to.

    However, I suspect you want column a to be included in the sort so I also changed it to a13:x83. Let me know if this isn't okay.


    Brooke
    Attached Files Attached Files

  3. #3
    2 Star Lounger
    Join Date
    Jul 2001
    Location
    Kuala Lumpur , MALAYSIA
    Posts
    154
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: sorting grades and marks...please help me.. (excel 97)

    Thank you..thank you thank you...Brooke..
    It works like charm so far.. <img src=/S/smile.gif border=0 alt=smile width=15 height=15>
    Appreciate it very much..Regards

Posting Permissions

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