Thanks everyone.
Sent on my BlackBerry® from Vodafone
-Original Message-
From: Kris
Sender: excel-macros@googlegroups.com
Date: Sun, 8 Apr 2012 06:34:59
To:
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Order by Rank
The formula should be
=RANK(A2,$A$2:$A$9
The formula should be
=RANK(A2,$A$2:$A$9)+COUNTIF($A$2:A2,A2)-1
Kris
>
>
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
qui
Please ignore previous attachment..
Rajan.
From: Rajan_Verma [mailto:rajanverma1...@gmail.com]
Sent: Apr/Sun/2012 06:31
To: 'excel-macros@googlegroups.com'
Subject: RE: $$Excel-Macros$$ Order by Rank
Hi krish,
Please explain the result in attached sheet..
I think its
Hi krish,
Please explain the result in attached sheet..
I think its not giving correct result..
Rajan.
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Kris
Sent: Apr/Sun/2012 03:52
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros
Hi
Try
=RANK(A2,$A$2:$A$20)+COUNTIF($A$2:A2,A2)-1
adjust the range.
Kris
--
FORUM RULES (986+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get
q
-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
> On Behalf Of joseph.cam...@gmail.com
> Sent: Apr/Sat/2012 11:14
> To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Order by Rank
>
> Yes it is either ascending or descending. But if there are two ra
: Re: $$Excel-Macros$$ Order by Rank
Yes it is either ascending or descending. But if there are two ranks the
same for example 3 is twice then it does not work.
Sent on my BlackBerryR from Vodafone
-Original Message-
From: "Rajan_Verma"
Sender: excel-macros@googlegroups.com
Date:
Reply-To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Order by Rank
You can sort in descending order
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of joseph.cam...@gmail.com
Sent: Apr/Sat/2012 10:56
To: ex
Hi
Can yu pls attached sample worksheet ?
On Sat, Apr 7, 2012 at 10:55 PM, wrote:
> Hi,
>
> I want to reorder products by rank in a particular order. It works fine
> when the rank is unique. But when there are two products of same rank then
> it does not. Please help.
>
> I reorder using index
You can sort in descending order
Rajan.
-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of joseph.cam...@gmail.com
Sent: Apr/Sat/2012 10:56
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Order by Rank
Hi,
I want to re
10 matches
Mail list logo