Xref: utzoo comp.databases:3456 comp.misc:6883
Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!rutgers!usc!ginosko!uunet!ncrlnk!cipc1!mfox
From: mfox@cipc1.Dayton.NCR.COM (Mark Fox)
Newsgroups: comp.databases,comp.misc
Subject: Spreadsheet Formula Needed
Message-ID: <1266@cipc1.Dayton.NCR.COM>
Date: 29 Aug 89 14:18:12 GMT
Reply-To: mfox@cipc1.Dayton.NCR.COM (Mark Fox)
Followup-To: comp.databases
Distribution: na
Organization: NCR Corporate Technical Support & Planning - Dayton, OH
Lines: 15


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