HELP please! how do I return 2 separate results with the same value

I have just created an excel program for some soccer leagues however I seem to have run into a problem for when 2 scores are the same.

Say for e.g. Team 1 score 50 points, Team 2 scores 35, Team 3 scores 35, and Team 4 scores 30.
What I am trying to do is return the 3 highest points. Currently i use an IF formula to say if the value is the largest in the set, then return team 1, if 2nd largest return team 2 etc.. However if 2 teams have the same value i will get an output like:
3 highest teams:
Team 1
Team 2
Team 2
Please if anybody can help me fix this problem it will be much appreciated!

Hi,

One way would be as follows. Assumes Teams are in column A and scores in column B
In C1 copied down

Formula:

Please Login or Register  to view this content.

Then if you wish Sort columns A:C with C as the key

Or use Pivot Table.