Results 1 to 5 of 5

How to clear the lowest 10 values from a list of 30 values

Threaded View

  1. #1
    Registered User
    Join Date
    04-01-2009
    Location
    dhk
    MS-Off Ver
    Excel 2003
    Posts
    1

    How to clear the lowest 10 values from a list of 30 values

    Suppose I have a database of 50 students. Each row starts with the name of the student and then marks of 30 quizes for each student. e.g.-

    Jack- 10 7 8 5 10 9 8 7 3 6 4 7 3 ........
    Millie- 2 3 10 9 8 2 7 1 2 9 2 0 7 9.......
    Ryan- 4 5 7 8 9 10 2 4 5 7 8 9............
    ...............................................................
    ..............................................................
    Now I want to count only best 20 quiz marks out of 30 quizes and show the cells containing 10 lowest values as blank.
    e.g. if i want to clear lowest 5 values for jack-
    Jack- 10 7 8 _ 10 9 8 7 _ _ _ 7 _ ....

    Now how do I do this and how do I repeat it for all 50 students? That is, how do I show only best 20 quiz marks out of 30 for each student?


    please help
    fap87
    Last edited by VBA Noob; 04-01-2009 at 05:08 PM.

Thread Information

Users Browsing this Thread

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

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