Function to replicate filter needed - time sensitive

[colinheslop1984]

A1 STYLE	B DEPARTMENT	C CATEGORY	D COLOUR	E VALUE
ADRIANA	WOMENS	JERSEY	PLUM	210
MAIZEY	WOMENS	NIGHTWEAR	TEAL	205
JACOB	MENS	KNITWEAR	NAVY	178
HAYWOOD	WOMENS	KNITWEAR	YELLOW	150
PENGUIN	WOMENS	NIGHTWEAR	PURPLE	105
ORGANIC	MENS	JERSEY	BLUE	79

<tbody>
</tbody>

I have a table of data like the one above only larger. I want to create a top 10 list based on criteria, the criteria being column's B and C.

I would like the below table to populate itself in order of value if column B meets the desired criteria's, e.g. women's AND nightwear. In essence it will work just like a filter

DEPARTMENT CRITERIA (E.G. WOMENS)

CATEGORY CRITERIA (E.G. NIGHTWEAR)

<tbody>
</tbody>

STYLE	COLOUR	VALUE
*FUNCTION NEEDED	*FUNCTION NEEDED	*FUNCTION NEEDED

<tbody>
</tbody>

DESIRED RESULT BELOW

STYLE	COLOUR	VALUE
MAIZY	TEAL	205
PENGUIN	PURPLE	105
AND SO ON

<tbody>
</tbody>

Any suggestions would be much appreciated

 

[Fluff]

Please do not post the same question multiple times. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).