Security & Virus | Hardware | Windows XP | Windows Vista | PC Gaming

need to create a program

Comment:

i have a worksheet with five coloums of number inputs from which i need to select the highest number & then from the remaining i need to select two second highest numbers and average them. how can i create such a program.

Name: DerbyDad03
Date: May 15, 2009 at 12:43:11 Pacific

Reply:

To return the highest number, try either MAX(A1:E3) or LARGE(A1:E3,1) Before we can average the 2nd and 3rd highest numbers, we may need some more info. What happens if the highest number repeats itself? e.g. If the highest 4 numbers are 50, 50, 49 and 48 would you want to see 49.5 or 48.5 as your Average of "the two second highest numbers"? If the highest number will never repeat itself anywhere in the range, or if you would accept 49.5 as the result of the example above, then this should work: =AVERAGE(LARGE(A1:E3,2),LARGE(A1:E3,3))

0

Importing CSV in Excel, c...

Macro to check columns an...

Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.

Summary: Hi, I can create a .pdf file using the software that came with my scanner, but I would like to know what software is needed to creat a .pdf file that will allow me to create a Table of Contents with l...

Summary: That worked perfect...just two question. First, is there a way that I can store the table in A12:B14 in a separate excel document stored on my hard drive. Second, is there a way to create a macro that...

Summary: I have just spent most of the morning trying to get Outlook 2003 to work after getting something like the following error message when I tried to run Outlook 2003... "Outlook could not start because a...