[comp.misc] Spreadsheet Formula Needed

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