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
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 anand...@gmail.com wrote:
with an improper contact number you expect me to reach you???
On Thu,
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 to
Hi Atul,
Not as tidy as Haseeb's response,
But here is one solution:
In C2:
=IF(ROW(C$2)=ROW(),LARGE($B$2:$B$11,1),LARGE($B$2:$B$11,ROWS($B$2:$B$11)-COU
NTIF($B$2:$B$11,INDEX(C$2:C$11,ROW()-2))+1))
In D2:
=MATCH($B2,$C$2:$C$11,-1)
Highlight and copy down.
Your ranking is in column D.
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