[plug] Open office calc

[Harry McNally]

David Dartnall wrote:
> Is there an OO calc expert  in our midst?
> 
> 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.
> 
> Any help or pointers appreciated.

There is quite a list if you start OOo Help, choose the index and select 
"functions->in Calc". Look through those. Choosing an algorithm using 
those functions would be handy if you could use a sort (didn't see one) 
or copy the row into a scratch row, find the index of the highest value 
(using max), sum that and then zero the indexed element and call max 
again .. repeat 7 times. It's manky but uses only max.

hth
Harry