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

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 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 not giving

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

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

2012-04-08 Thread joseph . camill
Thanks everyone. Sent on my BlackBerry® from Vodafone -Original Message- From: Kris krishnak...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 8 Apr 2012 06:34:59 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Order

$$Excel-Macros$$ Order by Rank

2012-04-07 Thread joseph . camill
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 formula. Thanks in advance, Joseph Sent on my BlackBerry® from Vodafone -- FORUM RULES (986+

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

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, joseph.cam...@gmail.com 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

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

2012-04-07 Thread joseph . camill
:59:25 To: excel-macros@googlegroups.com 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

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 rajanverma1...@gmail.com Sender: excel-macros

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

2012-04-07 Thread rags
@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 ranks the same for example 3