I'm not sure what you're looking for, but the LARGE function can
return the nth largest number from a range. For example,
=LARGE(A1:A10,1)
will return the largest number in A1:A10, and
=LARGE(A1:A10,2)
will return the second largest number in A1:A10
--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
"Mandley D" wrote in message
...
Dear All
I have an Excel worksheet and am wanting to make it
intereactive so scores
(from a questionaire/assessment) can be entered in by the user
and the
results of the assessment displayed.
What I'd like to know is how to write a formula/macro which
looks at 4
scores, notes the results of # 1 and# 2 in order, and displays
text based on
that score.
Is this possible in Excel ?
Many thanks in advance
DM