[plug] Open office calc

[Denis Brown]

At 08:52 PM 26/02/2006, Alex Nordstrom wrote:
>Sunday, 26 February 2006 19:33, Harry McNally wrote:
> > David Dartnall wrote:
> > > I need to get the sum of the 7 (say) highest numbers in each row.
> > > Sounds simple but all I've found are the basic functions which
> > > don't seem to fit the requirements.

Alex thought of LARGE.   Here is a url that describes another way of how to 
use it.   Essentially the technique makes use of a secondary array of 
cells, the dimension of N which in David's case is 7.

http://www.openofficetips.com/blog/archives/2005/03/largest_values.html

HTH,
Denis