formula for returning top 5 answers from a list

[BurkeDad]

I am creating a report that allows the user to select different facilities across the US and then have alot of data be condensed into this report format. One of the sections I is the top 5 occupational types - so depending on whcih state you select, the top 5 occupation types will be different. Thereofre I need a formula that will return the "TOP 5" in a list depending on which facility is selected.

At first I was thinking of "getppivotdata" or a if/then array. Anyone have suggestions on where I can start?

 

[Robert Mika]

You can use this formula to get as many TOP's as you need:

=LARGE($H$2:H2:H18,ROWS($A$1:A1))

(copy down)

if your data are in row H.


Could you post some real data from your sheet?