mfox@cipc1.Dayton.NCR.COM (Mark Fox) (08/29/89)
Need assistance in implementing a spreadsheet. I have multiple rows, each row will have 10 columns, each column will have an integer value or will be left blank. I need to calculate the sum of the 6 highest values in each row and store in the eleventh column of that row. The spreadsheet will be implemented in both SuperCalc 3 and Lotus 123. If you can devise a scheme that will work, I would greatly appreciate it. -- Mark Fox mfox@NCR.COM Home (513) 293-5472 Office (513) 445-6384
dberg@cod.NOSC.MIL (David I. Berg) (08/30/89)
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