Re: Excel Sort

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Max (demechanik_at_yahoo.com)
Date: 05/06/04 

Date: Thu, 6 May 2004 18:33:47 +0800

Maybe you're looking for RANK()?

Assuming your sample data is in A2:A5

> 33 2
> 34 1
> 32 3
> 32 3

Put in B2: =RANK(A2,$A$2:$A$5,0)

Copy B2 down to B5

B2:B5 will return the desired results 

--
Rgds
Max
xl 97
---
Please respond, in newsgroup
xdemechanik <at>yahoo<dot>com
----
"meral >" <<meral.15tt2f@excelforum-nospam.com> wrote in message
news:meral.15tt2f@excelforum-nospam.com...
> hÝ ALL
>
> 33  2
> 34  1
> 32  3
> 32  3
>
> Is there a function to make an unsorted column to a sorted colum n
> 1,2,3...
>
>
> i mean give max number to 1 second max number 2 thýrd max number 3
> etc...if number equals give same sort number...
>
>
> :confused:
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>
Quantcast