Retreive Top 5 Results If

[Dulanic]

Hello. I have some data (who doesn't) and I need to pull the top 5 rows for specific criteria.For example I may have 100 different rows of data with matching fields in column A. I want to, for example, take the top 5 (basically ranked) rows of data if column A = XYZ and the rank is based on numbers in another column. Then I want to do the same for ZYX next for column A. The values in A are predetermined and only specified values are even looked at. The rank column I just used to show their rank but doesnt exist and I don't know how to do rankif so I kind of just did that by hand partly.

Hope this makes sense... I attached an example file.

[NBVC]

Here's one way..

Add helper in Data,at H2:

Please Login or Register  to view this content.

copied down

in I2:

Please Login or Register  to view this content.

in A2 of Result sheet:

Please Login or Register  to view this content.

copied down as far as you need... adjust ranges to suit.

in F2 of Result sheet:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied down

in B2:

Please Login or Register  to view this content.

confirmed with CTRL+SHIFT+ENTER and copied down and across to column E

[NBVC]

One of my formulas above was slightly off (column F)... please look at the new attachment above instead..