troubleshooting Question

Need a formula to assign ranks/positions based on the percentage values in one column

Avatar of masmatc
masmatc asked on
Microsoft OfficeMicrosoft ExcelMicrosoft Applications
4 Comments1 Solution459 ViewsLast Modified:
Hi there,

Please see the attached file

1) Need to have a formula in column F.
2) Based on the column E result (percentage) assign the position in the class for example 1st, 2nd, 3rd, 4th, 5th or just 1, 2, 3, 4, 5 and so on till the last item of the data/list (and that can be any number of students)
3) In-case of same exact percentage then need to check P.NO.  and the lowest P.NO.  gets more weight-age/preference. For example in the given example P.NO. 101 and P.NO. 109 has the same percentage but with the P.NO. 101 will be above in the position above then P.NO. 109

Best Regards
Join our community to see this answer!
Unlock 1 Answer and 4 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 4 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros