Chronology Current Month Current Thread Current Date
[Year List] [Month List (current year)] [Date Index] [Thread Index] [Thread Prev] [Thread Next] [Date Prev] [Date Next]

Re: Grading & EXcel

At 02:18 PM 12/14/1997 -0500, you wrote:
Richard Bowman's solution below IS the best I've seen--has Excel always had
the 'SMALL' function or is that new? Is there an equivalent in Quattro (I'm
a fairly recent convert from WP/QPRO to Word/Excel and searched rather
extensively for such a function in QPRO (versions 6 and earlier)?


Piqued by your question I have just grabbed my macro manual for QPro version
5, and found the function

@smallest(Array,N)

Array = a numeric array or a block of values.
N = number that indicates teh rank in size from the data set Array.

Example: @Smallest(3,45,8,4,7,6,13,2,87,23,58,14,17,21),5) = 7

Smallest finds the Nth smallest number in Array. If there are duplicates,
@Smallest treats then as separate numbers.

I wish I had found this a few years ago!
Regards,

Patrick W. Whippey EMail: pwhippey@julian.uwo.ca
Department of Physics & Astronomy Phone: 519-661-2111 x 6431
University of Western Ontario Fax: 519-661-2033
London Ont N6A 3K7