[plug] Open office calc

[David Dartnall]

On Sun, 26 Feb 2006 09:33 pm, Denis Brown wrote:
> 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
>
Thank you Harry, Alex and Denis - that's given good clues to follow tomorrow.
I'll let you know how it goes.
Dave D