I guess "nice" is in the eye of the beholder. I view this as
another good reason NOT to use Excel for Statistics!
Please use the right tool for the job.
Jon Cryer
At 05:58 PM 11/26/99 +0100, you wrote:
>Very nice solution.
>It can be reduced even to the last part:
>RANK(A1,A$1:A$6,1)+(COUNTIF(A$1:A$6,A1)-1)/2)
>
> Ivan
>
>> You can modify the rank() function using the following one:
>>
>> IF(COUNTIF(A$1:A$6,A1)=1, RANK(A1,A$1:A$6,1),
>> RANK(A1,A$1:A$6,1)+(COUNTIF(A$1:A$6,A1)-1)/2)
>>
>> In this setting, the data range is A1:A6 (as the example you mentioned in
>> your email), and ranking is in the ascending order, e.g. smaller number
>> gets smaller rank. You can type this function in cell B1, and copy the
>> formula to B1:B6. Let me know if you need further info.
>>
>> Jay
>>
>
>********************************************************
> Ivan Zezula, Safarik University, Kosice
>
>
_____________
------------------------------------------------- | \
Jon Cryer [EMAIL PROTECTED] ( )
Department of Statistics http://www.stat.uiowa.edu\ \_ University
and Actuarial Science office 319-335-0819 \ * \ of Iowa
The University of Iowa dept. 319-335-0706 \ / Hawkeyes
Iowa City, IA 52242 FAX 319-335-3017 |____________ )
------------------------------------------------- V