Excel formula to pull Top 5 -

i trying figure out how pull top (and bottom) 5 items sold particular group, cannot figure out. suggestions?

enter person want check in green box populate fields.

        paul         jake            john                 steve                jake      salesman    item     amount              paul    blue     202        top 5 items sold     paul    orange   1,500           paul    green    28              paul    pink     62              paul    purple   10,215              paul    cherry   1,616           paul    soda     1,320           paul    tea  1,598      bottom 5 items sold  paul    coffee   22              paul    pop  165             paul    grass    148             paul    weeds    3           paul    tar  147             john    eyes     169             john    teeth    1,258           john    arm  1,247           john    leg  1,396           john    foot     13,598              john    hand     12,458              john    finger   12,477              john    nailfile     1,036           john    brush    4,567           steve   comb     8,901           steve   tweezer  2,345           steve   charger  3,456           steve   plate    4,567           steve   bowl     5,678           steve   cup  6,789           steve   spoon    7,890           steve   knife    8,902           jake    fork     8,998           jake    tongs    1,723           jake    spatula  9,856           jake    cookie jar   1,616           jake    cracker  2,589           jake    cake     1,628           jake    pie  528,116             jake    cupcake  5,286           

you can use following formula, assumes

• your data starts in second row
• the persons name interested in in d2
• all names in column a
• all items in column b
• all values in column c

• you type formula cell e1 , drag down there

  {=min(if(((large(if(($a$2:$a$22=$d$2),$c$2:$c$22),rows($a$2:a2)))=$c$2:$c$22)*(countifs($e$1:e1,$b$2:$b$22)=0),$b$2:$b$22))} 

for smallest values, replace large small.