Re: Ranking numbers AND text

From: Harlan Grove (hrlngrv_at_aol.com)
Date: 05/14/04 

Date: Fri, 14 May 2004 18:33:38 GMT

"Neil G" wrote...
>No, not really sorting, I don't want to have to sort them manually, but rank
>them automatically.
..
>"Harlan Grove" <hrlngrv@aol.com> wrote in message
..
>>B1:
>>=IF(ISNUMBER(A1),COUNTIF($A$1:$A$6,"<"&A1)+COUNT($A$1:$A$6),
>>COUNTIF($A$1:$A$6,">"&A1))
..

I suppose it wasn't obvious, but if the formula above could be used to sort the
range of your sample values (assumed in A1:A6), then the formula also gives the
ranking you're seeking. The specific formula above gives the ranking of cell A1
in A1:A6, where A1 contains 1, and the formula returns 3. 

--
To top-post is human, to bottom-post and snip is sublime.