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