Return Nth instance of text string

[Partjob]

I have the following formula that returns the most frequently occuring string in a range. what I would like to do is return the 2nd, 3rd 4th and 5th most common occourance as well. I am not sure if I can do this by adjusting this formula or whether that would be a completely diffent formula or worst case senario it is not possible at all.

=INDEX(B2:B1537,MATCH(MAX(COUNTIF(B2:B1537,B2:B1537)),COUNTIF(B2:B1537,B2:B1537),0))

obviously this is an array.

Partjob

 

[xld]

Thank you all for your help.
For the record xld's solution worked for me.
andrew's didn't give me the required result for the reason stated in the thread.
Richard's returned N/A not really sure why?
It would be nice if it was all in one formula but what I have works so what more can I ask.
Thanks again
Partjob

Richard's fails if you have blanks in the range, mine was more generic.

 

[Richard Schollar]

Good spot Bob. My formula could be amended to:

=INDEX($A$1:$A$15,MATCH(TRUE,COUNTIF($A$1:$A$15,$A$1:$A$15&"")=LARGE(FREQUENCY(MATCH($A$1:$A$15&"",$A$1:$A$15&"",0),MATCH($A$1:$A$15&"",$A$1:$A$15&"",0)),2),0))

to take account, but it counts blank cells as a valid return (so it will return 0 if blanks are the second most populous result in the above)