+ 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. 25th November 2008, 10:38 PM #1
    tw15ns
    tw15ns is offline
    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
    Reply With Quote Reply With Quote
  2. 25th November 2008, 10:47 PM #2
    ChrisH
    ChrisH is online now
    ChrisH's Avatar
    Join Date
    Jun 2005
    Location
    East Lancs
    Posts
    4,756
    Thank Post
    85
    Thanked 203 Times in 186 Posts
    Rep Power
    81
    Sounds like more of a job for VBA than a function.
    Reply With Quote Reply With Quote
SHARE:
+ Post New Thread

Similar Threads

  1. VBA: Control ID -> function?
    By PiqueABoo in forum Coding
    Replies: 0
    Last Post: 25th November 2008, 04: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, 11:20 AM
  4. FN + F5 function key does not work
    By alexknight in forum Hardware
    Replies: 8
    Last Post: 7th February 2007, 03:32 PM
« Checking full revision history/summary on a document | Sharepoint »

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
  •  

Forum Rules