Function to select the 6 highest numbers

Thread View: comp.apps.spreadsheets

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Mark Fox Fri, 09 Oct 1992 19:22

#190

Author: 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

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