sorting discarding repeated

[maujor]

Say I have:

Please Login or Register  to view this content.

In column 1 aaa, bbb, ccc, ddd are teams representing associations competing with each other. The number of teams per association is free, but only the best placed team will count for final classification.
In column 2 are the final team's classification.

Question is:
How do I order in column 3 final association's classification.
resulting column 3 in:

Please Login or Register  to view this content.

Thanks for any help.