[plug] Open office calc

David Dartnall darts at dialix.com.au
Sun Feb 26 19:42:08 WST 2006


On Sun, 26 Feb 2006 07:33 pm, 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.
> >
> > 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
>
Thanks Harry, there is a sort which I've used in the past, then summed the top 
(7) elements but this had to be done individually for each row and 'ruined 
the look of the sheet' - numbers no longer related to their headings etc.

This is the sort of thing I was thinking of but don't really know how to do it 
or zero the max found before moving on to the next one... How does max return 
the index of the value found?

Is there a loop construct available?

regards
Dave D



More information about the plug mailing list