extracting top 4 rows

[np1966]

here is the table. how to extract the top4 amounts for each type using a macro
type amount
poor 1500
poor 1700
poor 1800
poor 1700
poor 1800
poor 1850
poor 1950
poor 1975
poor 1550
poor 1450
rich 10000
rich 11000
rich 11000
rich 12000
rich 14000
rich 13500
mass 500
mass 800
mass 400
mass 550
mass 450

[MarvinP]

Hi np1966,

I can do this problem with array formulas. They are also called Control Shift Enter formulas (CSE).
Read http://www.cpearson.com/excel/ArrayFormulas.aspx
and see the attached for an answer.

[np1966]

thanks for the reply. but the actual requirement is like this