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
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
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
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
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
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+
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
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
: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
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
@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
11 matches
Mail list logo