need to create a program

May 15, 2009 at 07:51:00
Specs: Windows Vista, pentium/2gb
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.

See More: need to create a program

Report •

May 15, 2009 at 12:43:11
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:


Report •
Related Solutions

Ask Question