Very simple stuff for you...but I cant figure it out yet.....
I have 100 people in a list and they are Ranked (I have used the Rank formula) as per the Number of People that report to them. Wherever there's a tie, it is skipping for next number, e.g.
Rank 1
Rank 1
Rank 3
the above is if the top 2 positions are tied. I need
Rank 1
Rank 1
Rank 2
How do I get this? I am using only One Parameter to calculate Rank. Please help !!
~Sachin Attri~
Hi Sachin,
See the attached file where I have transferred your case and designed a solution to meet your requirement.
Let me know if this helps.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), [email protected]
Try
=SUM(1/COUNTIF(B$1:B$100,B$1:B$100)*(B$1:B$100<B1))+1 enter with Ctrl+Shift+Enter
Then copy dwn
Try
Depend which way lower or higher
=SUM(1/COUNTIF(B$1:B$100,B$1:B$100)*(B$1:B$100>B1))+1 enter with Ctrl+Shift+Enter
or
=SUM(1/COUNTIF(B$1:B$100,B$1:B$100)*(B$1:B$100<B1))+1 enter with Ctrl+Shift+Enter
Then copy dwn
Thank you very much all of you !!
You are welcome Mr.Attri
Please mark this thread as [SOLVED]
Regards,
DILIPandey
<click on below * if this helps>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks