I do not know which function to use, but I can tell you what I need it to do.

I have a list of 50 people, I also have a list of their 50 rankings(good, bad, ugly,etc.).

I have a list of the possible rankings.

I need a function that will go through the list of people and their rankings and find all of the people with the same rankings and put all of the people in the same ranking in an individual cell.

any ideas?
Thanks!