Hi Atul,
Rank function seems to work perfectly fine here Copied the name of
Institutions to A column and percentages to column B in C2 the formula was
=RANK(B2,$B$2:$B$11,0) now drag the formula till C11 you get the desired
result.
Warm regards,
Anand Kumar
On Wednesday, 21 March 2012 02
Hi Anand,
Thank you for your response.Please refer to the calculation below. For
repetitive items,rank formula removes subsequent rank for example 11 % rank 3
is not assigned due to multiple entry for the same standing.
I want to ignore repetitive occurrences of rates and decide first, Second th
My apology! I am overseas. Just email reply will be ok How ever if you want to
dicuss on this I can call you too Pl provide your contact.
Sent from my iPhone
On 2012-03-22, at 9:27, Anand Kumar wrote:
> with an improper contact number you expect me to reach you???
>
> On Thu, Mar 22, 2012 at
Hello Atul, try this
Assume B2:B11 is %, in C2 then copy down.
=SUMPRODUCT((ISNUMBER(MATCH(ROW(INDEX(A:A,1):INDEX(A:A,RANK(B2,B$2:B$11))),INDEX(RANK(B$2:B$11,B$2:B$11),0),0))+0))
___
HTH, Haseeb
On Wednesday, March 21, 2012 12:24:21 AM UTC+3, Atul wrote:
>
>
> Hi,
>
> I need help
oups.com]
On Behalf Of Atul Patel
Sent: Thursday, March 22, 2012 6:49 AM
To: Anand Kumar
Cc: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Re: Help to find position of a particular number
in a given data set
My apology! I am overseas. Just email reply will be ok How ever if you want
t