Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!tut.cis.ohio-state.edu!ucbvax!agate!helios.ee.lbl.gov!nosc!cod!dberg
From: dberg@cod.NOSC.MIL (David I. Berg)
Newsgroups: comp.databases
Subject: Re: Spreadsheet Formula Needed
Summary: Use the ARRANGE command
Message-ID: <1619@cod.NOSC.MIL>
Date: 29 Aug 89 17:22:19 GMT
References: <1266@cipc1.Dayton.NCR.COM>
Distribution: na
Organization: Naval Ocean Systems Center, San Diego
Lines: 15

In article <1266@cipc1.Dayton.NCR.COM>, mfox@cipc1.Dayton.NCR.COM (Mark Fox) writes:
> I need to calculate the sum of the 6 highest values in each row and
> store in the eleventh column of that row.

In Supercalc you can use the ARRANGE command to sort the rows by column
in ascending or descending order.  Since you have a discrete number 
of columns, you will then have access to the six highest values in
each row.  I'm not sure how you would implement the equivalent command
in Lotus.

-- 
David I. Berg (dberg@nosc.mil)
GENISYS Information Systems, Inc., 4250 Pacific Hwy #118, San Diego, CA 92110
MILNET: dberg@nosc.mil
UUCP:   {akgua decvax dcdwest ucbvax}!sdcsvax!noscvax!dberg