Re: Function to select the 6 highest numbers

Article View: comp.apps.spreadsheets

Article #186

Back to comp.apps.spreadsheets Previous Next

#186

From: Erich Neuwirth
Date: Sat, 10 Oct 1992 07:58

26 lines
1518 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
i don't know if this is available in excel 3.0, but excel 4.0
has a function
small(k,range)
which will give you the k-th smallest value of range.
so it is a sort, but not a menu sort which has to be updated
when  you change the values,
but a "live" sort which is updated like a normal formula.
in fact, it is a normal formula
erich neuwirth
p.s.: you should try to upgrade to version 4.0 as soon as possible,
it really is MUCH better than 3.0. which already was very good.



--
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: <1992Oct10.080256.5568@newssrv.edvz.univie.ac.at>

Path: arc1-ca.pugleaf.net!sparky!uunet!news.univie.ac.at!vm.univie.ac.at!A4422DAB

Show Full Headers

Complete Article Headers

Newsgroups: comp.apps.spreadsheets
Path: arc1-ca.pugleaf.net!sparky!uunet!news.univie.ac.at!vm.univie.ac.at!A4422DAB
From: A4422DAB@vm.univie.ac.at (Erich Neuwirth)
Subject: Re: Function to select the 6 highest numbers
Message-ID: <1992Oct10.080256.5568@newssrv.edvz.univie.ac.at>
Sender: news@newssrv.edvz.univie.ac.at (News System - Vienna University)
Nntp-Posting-Host: helios.edvz.univie.ac.at
Organization: University of Vienna
Date: Sat, 10 Oct 1992 07:58:24 GMT
Lines: 27