Hello Everyone,
I am needing a formula that provides the correct ranking from a list of 1000 employee's...
The data is pulled from another sheet in the workbook and displayed on another sheet.. The formula needs to attain the data from a list of 1000 employees and display the top 25 and Rank the Top 25... Any Idea's would be appreciated
Best Regards,
John
Last edited by JJFletcher; 07-23-2016 at 02:04 PM.
JJ,
that isn't enough detail to help. Is the rank based on some score? Or is it alphabetical?
Best if you attach a sample sheet.
Cheers
<-- If you're happy & you know it...click the star.:-)
Hi Amit,
I have attached a sample sheet for review... Is this good enough of an example?
Best Regards,
John
Last edited by JJFletcher; 07-23-2016 at 12:33 PM.
Hi there,
Take a look at the attached version of your workbook and see if it does what you need.
It uses the following code:
The highlighted values can be altered to suit your own requirements.
Please Login or Register to view this content.
Clicking on the "Rank Employees" button will produce the ranking based on the data contained in Sheet2. The Sheet1 worksheet also takes account of situations where employees have equal scores and assigns joint rankings to each of them.
Hope this helps - please let me know how you get on.
Regards,
Greg M
Hi Greg,
Thank you so much - I really appreciate this code...This is outstanding - Excellent - Works perfectly!
Thanks Again!
John
Last edited by JJFletcher; 07-23-2016 at 02:05 PM.
Hi again John,
Many thanks for your feedback and also for the Reputation increase - much appreciated
You're very welcome - glad I was able to help.
Best regards,
Greg M
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks