Function to replicate filter needed - time sensitive

[colinheslop1984]

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]A1 STYLE[/TD]
[TD]B DEPARTMENT[/TD]
[TD]C CATEGORY[/TD]
[TD]D COLOUR[/TD]
[TD]E VALUE[/TD]
[/TR]
[TR]
[TD]ADRIANA[/TD]
[TD]WOMENS[/TD]
[TD]JERSEY[/TD]
[TD]PLUM[/TD]
[TD]210[/TD]
[/TR]
[TR]
[TD]MAIZEY[/TD]
[TD]WOMENS[/TD]
[TD]NIGHTWEAR[/TD]
[TD]TEAL[/TD]
[TD]205[/TD]
[/TR]
[TR]
[TD]JACOB[/TD]
[TD]MENS[/TD]
[TD]KNITWEAR[/TD]
[TD]NAVY[/TD]
[TD]178[/TD]
[/TR]
[TR]
[TD]HAYWOOD[/TD]
[TD]WOMENS[/TD]
[TD]KNITWEAR[/TD]
[TD]YELLOW[/TD]
[TD]150[/TD]
[/TR]
[TR]
[TD]PENGUIN[/TD]
[TD]WOMENS[/TD]
[TD]NIGHTWEAR[/TD]
[TD]PURPLE[/TD]
[TD]105[/TD]
[/TR]
[TR]
[TD]ORGANIC[/TD]
[TD]MENS[/TD]
[TD]JERSEY[/TD]
[TD]BLUE[/TD]
[TD]79[/TD]
[/TR]
</tbody>[/TABLE]












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

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]DEPARTMENT CRITERIA (E.G. WOMENS)[/TD]
[TD]CATEGORY CRITERIA (E.G. NIGHTWEAR)[/TD]
[/TR]
</tbody>[/TABLE]



[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[TD]STYLE[/TD]
[TD]COLOUR[/TD]
[TD]VALUE[/TD]
[/TR]
[TR]
[TD]*FUNCTION NEEDED[/TD]
[TD]*FUNCTION NEEDED[/TD]
[TD]*FUNCTION NEEDED[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]









DESIRED RESULT BELOW

[TABLE="class: grid, width: 500, align: left"]
<tbody>[TR]
[/TR]
[TR]
[TD]STYLE[/TD]
[TD]COLOUR[/TD]
[TD]VALUE[/TD]
[/TR]
[TR]
[TD]MAIZY[/TD]
[TD]TEAL[/TD]
[TD]205[/TD]
[/TR]
[TR]
[TD]PENGUIN[/TD]
[TD]PURPLE[/TD]
[TD]105[/TD]
[/TR]
[TR]
[TD]AND SO ON[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]







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).