Thread View: comp.apps.spreadsheets
1 messages
1 total messages
Started by Erich Neuwirth
Sat, 10 Oct 1992 07:58
Re: Function to select the 6 highest numbers
Author: Erich Neuwirth
Date: Sat, 10 Oct 1992 07:58
Date: Sat, 10 Oct 1992 07:58
26 lines
1518 bytes
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
Thread Navigation
This is a paginated view of messages in the thread with full content displayed inline.
Messages are displayed in chronological order, with the original post highlighted in green.
Use pagination controls to navigate through all messages in large threads.
Back to All Threads