Function to select the 6 highest numbers

Article View: comp.apps.spreadsheets

Article #190

Back to comp.apps.spreadsheets Previous Next

#190

From: Mark Fox
Date: Fri, 09 Oct 1992 19:22

13 lines
993 bytes

I am using Excel 3.0 and need to be able to perform the following:
For each row in the spreadsheet, I need to compute the summation
of the 6 highest numbers.  Each row contains ten cells.  A cell 
may or may not contain a value.  Does anyone know an easy way
to do this.

Mark Fox

-- 
Mark Fox  Office (513) 445-6384 FAX (513) 445-2468
Mark.Fox@DaytonOH.NCR.COM  or   Mark.Fox%DaytonOH.NCR.COM@UUNET.UU.NET
NCR CITIS (Corporate Information Technology Integration Services)
Mark Fox, NCR PCD-6, 1700 South Patterson Blvd., Dayton, Ohio 45479

Technical Details

Message-ID: <752@cspa.DaytonOH.NCR.COM>

Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!gatech!hubcap!ncrcae!ncrlnk!ciss!cspa!mfox

Show Full Headers

Complete Article Headers

Path: arc1-ca.pugleaf.net!sparky!uunet!haven.umd.edu!darwin.sura.net!gatech!hubcap!ncrcae!ncrlnk!ciss!cspa!mfox
From: mfox@cspa.DaytonOH.NCR.COM (Mark Fox)
Newsgroups: comp.apps.spreadsheets
Subject: Function to select the 6 highest numbers
Message-ID: <752@cspa.DaytonOH.NCR.COM>
Date: 9 Oct 92 19:22:31 GMT
Reply-To: mfox@cspa.DaytonOH.NCR.COM (Mark Fox)
Distribution: world
Organization: Corporate Information Technology Integration
Lines: 13