Re: $$Excel-Macros$$ Order by Rank

2012-04-08 Thread joseph . camill
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

Re: $$Excel-Macros$$ Order by Rank

2012-04-08 Thread Kris
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

RE: $$Excel-Macros$$ Order by Rank

2012-04-08 Thread Rajan_Verma
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

RE: $$Excel-Macros$$ Order by Rank

2012-04-08 Thread Rajan_Verma
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

Re: $$Excel-Macros$$ Order by Rank

2012-04-08 Thread Kris
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

Re: $$Excel-Macros$$ Order by Rank

2012-04-07 Thread rags
-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

2012-04-07 Thread Rajan_Verma
: 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:

Re: $$Excel-Macros$$ Order by Rank

2012-04-07 Thread joseph . camill
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

Re: $$Excel-Macros$$ Order by Rank

2012-04-07 Thread vijayajith VA
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

RE: $$Excel-Macros$$ Order by Rank

2012-04-07 Thread Rajan_Verma
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