large function multiple conditions

hi,

i'm not sure if this is possible however, i would like to know if there is a way to achieve my end result in the attached example data using a formula. i can achieve my end result by manually sorting the data or using a pivot table. i am wondering if a formula can achieve this as it will save loads of time!

in the example data i am trying to identify the top 5 and bottom 5 for a particular week, see data attached.

if this is easily possible with a formula great. if not i appreciate your help.

any more info needed just shout.

thanks!

j