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!


--
gtg689a
------------------------------------------------------------------------
gtg689a's Profile: http://www.excelforum.com/member.php...o&userid=33188
View this thread: http://www.excelforum.com/showthread...hreadid=530055