# Ranking two variables

1. ## Ranking two variables

Hi there,

I was wondering if someone would be able to help with a ranking formula I am trying to do.
I have attached a sheet which shows the problem I'm trying to solve.
I have a list of names and the "class" that each name belongs to. I then have scores / ranks for each day of the week (some of the ranks are the same!)
In column L I have a data validation so I basically just want to be able to select the day and select the class and have it return the list of names and their rank for that day. So for example, if I selected Tuesday and Class A, it would automatically show the 4 names (& order) I have shown in the picture in green.

Hopefully this makes sense and you can sort of understand what I'm getting at!
Any help would be so appreciated.
Thanks everyone.

Sam

2. ## Re: Ranking two variables

What criteria do you wish to use for ranking when there are identical scores? Jack and Owen are the same on Tuesday.

3. ## Re: Ranking two variables

Is it possible to have them so they are equal ranks? So both of them have a rank of 3?
I know my table in green showed 3 and 4.... ignore that!!
Thank you

4. ## Re: Ranking two variables

Yes. I believe so.

5. ## Re: Ranking two variables

Hope this works, pls see the file attach

regards

6. ## Re: Ranking two variables

Pl see attached file

7. ## Re: Ranking two variables

Thank you very much to both of you with those answers... very much appreciated

8. ## Re: Ranking two variables

Another slightly different approach; different results. Helper column P. Array entered.
Formula:
`Please Login or Register  to view this content.`
Ranking column O.
Formula:
`Please Login or Register  to view this content.`
Names column N.
Formula:
`Please Login or Register  to view this content.`
File is attached.

There are currently 1 users browsing this thread. (0 members and 1 guests)