+ Post New Thread
Results 1 to 2 of 2
Office Software Thread, Capped 8 Function in Technical; We have a spreadsheet with results from a termly review of our Key Stage 4 students. I have been asked ...
  1. #1

    Join Date
    Sep 2008
    Location
    Newcastle upon Tyne
    Posts
    17
    Thank Post
    0
    Thanked 1 Time in 1 Post
    Rep Power
    0

    Capped 8 Function

    We have a spreadsheet with results from a termly review of our Key Stage 4 students. I have been asked if I can find the total of the eight best results for each student. Can anyone think of a function in Excel that will sum the eight highest results from a range of marks.

    Thanks

  2. #2
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,941
    Thank Post
    115
    Thanked 272 Times in 250 Posts
    Rep Power
    104
    Sounds like more of a job for VBA than a function.

SHARE:
+ Post New Thread

Similar Threads

  1. VBA: Control ID -> function?
    By PiqueABoo in forum Coding
    Replies: 0
    Last Post: 25th November 2008, 03:45 PM
  2. [function.fopen] error
    By Gatt in forum EduGeek Joomla 1.0 Package
    Replies: 9
    Last Post: 29th April 2008, 12:23 PM
  3. Easy spreadsheet function
    By park_bench in forum MIS Systems
    Replies: 1
    Last Post: 19th March 2008, 10:20 AM
  4. FN + F5 function key does not work
    By alexknight in forum Hardware
    Replies: 8
    Last Post: 7th February 2007, 02:32 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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