Finding the Greatest Number

Hello!
I know you guys 'n gals are smart as whips!
I'm trying to get a formula to extract the top 5 highest numbers in a column.

In A1 to A9000 there are names and in B1 to B9000 are the numbers of times these names show up off of a different work sheet.

I need a formula in C1 to pick out the top five numbers from the B column and display them in C2,C3,C4,C5 and C6 along with the name, if possible.

These numbers range from 0 - 1000.

Any help would be greatly appreciated!

For your example you could use this formula in D2 copied down

=LARGE(B$2:B$12,ROWS(D$2:D2))

and then in C2

=INDEX(A$2:A$12,SMALL(IF(B$2:B$12=D2,ROW(B$2:B$12)-ROW(B$2)+1),COUNTIF(D$2:D2,D2)))

confirmed with CTRL+SHIFT+ENTER and copied down

That will cope with ties

For future ref. you could also use a "Top n" based Pivot Table but that would require a Refresh as and when the source data updated (or use of VBA)

you havent entered it as an array as instructed
see link in my signature "how to enter array formula"