colinheslop1984
Board Regular
- Joined
- Oct 14, 2016
- Messages
- 129
- Office Version
- 2016
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