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]

How about

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J
1	A1 STYLE	B DEPARTMENT	C CATEGORY	D COLOUR	E VALUE		Womens	A1 STYLE	D COLOUR	E VALUE
2	ADRIANA	WOMENS	JERSEY	PLUM	210		Nightwear	MAIZEY	TEAL	205
3	MAIZEY	WOMENS	NIGHTWEAR	TEAL	205			PENGUIN	PURPLE	105
4	JACOB	MENS	KNITWEAR	NAVY	178
5	HAYWOOD	WOMENS	KNITWEAR	YELLOW	150
6	PENGUIN	WOMENS	NIGHTWEAR	PURPLE	105
7	ORGANIC	MENS	JERSEY	BLUE	79
Jan2

Cell Formulas
Range	Formula
H2	{=IFERROR(INDEX($A$2:$E$7,SMALL(IF(($B$2:$B$7=$G$1)*($C$2:$C$7=$G$2),ROW($A$2:$A$7)-1),ROW($G1)),1),"")}
I2	{=IFERROR(INDEX($A$2:$E$7,SMALL(IF(($B$2:$B$7=$G$1)*($C$2:$C$7=$G$2),ROW($A$2:$A$7)-1),ROW($G1)),4),"")}
J2	{=IFERROR(INDEX($A$2:$E$7,SMALL(IF(($B$2:$B$7=$G$1)*($C$2:$C$7=$G$2),ROW($A$2:$A$7)-1),ROW($G1)),5),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[colinheslop1984]

How would that formula look if I wanted to remove the criteria for column B (DEPARTMENT). SO only one criteria, that being the category column

 

[Fluff]

Just remove the part in red from each formula
=IFERROR(INDEX($A$2:$E$7,SMALL(IF(($B$2:$B$7=$G$1)*($C$2:$C$7=$G$2),ROW($A$2:$A$7)-1),ROW($G1)),1),"")

 

[colinheslop1984]

=IFERROR(INDEX($A$2:$E$7,SMALL(IF(($B$2:$B$7=$G$1)*($C$2:$C$7=$G$2),ROW($A$2:$A$7)-1),ROW($G1)),1),"")

What about this bit at the end in red?

 

[Fluff]

Leave that as is

 

[colinheslop1984]

That isn't showing me any data, the cells just appear empty

 

[Fluff]

Should work

Excel 2013/2016
	A	B	C	D	E	F	G	H	I	J
1	A1 STYLE	B DEPARTMENT	C CATEGORY	D COLOUR	E VALUE			A1 STYLE	D COLOUR	E VALUE
2	ADRIANA	WOMENS	JERSEY	PLUM	210		Nightwear	MAIZEY	TEAL	205
3	MAIZEY	WOMENS	NIGHTWEAR	TEAL	205			PENGUIN	PURPLE	105
4	JACOB	MENS	KNITWEAR	NAVY	178			ORGANIC	BLUE	79
5	HAYWOOD	WOMENS	KNITWEAR	YELLOW	150
6	PENGUIN	WOMENS	NIGHTWEAR	PURPLE	105
7	ORGANIC	MENS	NIGHTWEAR	BLUE	79
Jan2

Cell Formulas
Range	Formula
H2	{=IFERROR(INDEX($A$2:$E$7,SMALL(IF(($C$2:$C$7=$G$2),ROW($A$2:$A$7)-1),ROW($G1)),1),"")}
I2	{=IFERROR(INDEX($A$2:$E$7,SMALL(IF(($C$2:$C$7=$G$2),ROW($A$2:$A$7)-1),ROW($G1)),4),"")}
J2	{=IFERROR(INDEX($A$2:$E$7,SMALL(IF(($C$2:$C$7=$G$2),ROW($A$2:$A$7)-1),ROW($G1)),5),"")}
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[colinheslop1984]

Rank	Style Name	Colour	Units	Value
1	STAR JUMPER	BLU-NAVY	3	148.5
2	HAYWOOD CARDIGAN	YEL-GOLDEN HAZE	3	143.55
3	SUZIE SWING ROLL NECK	BLK-PHANTOM	2	110
4	CHARLOTTE CASHMERE JUMPER	PNK-SEASHELL	1	98
5	ALICIA HOODIE X	BLU-NAVY	1	55
6	ALICIA HOODIE X	BLU-NAVY	1	55
7	ALICIA HOODIE X	BLU-NAVY	1	55
8	ALICIA HOODIE X	BLU-NAVY	1	55
9	HAYWOOD CARDIGAN	PNK-ROSE ASH	1	49.5
10	HAYWOOD CARDIGAN	PNK-ROSE ASH	1	49.5
11	LIZZIE CARDI	GRN-BOTTLE GRN	1	45
12	HAYWOOD CARDIGAN	NAT-IVORY	1	44.55
13	HOLLY CHENILLE JUMPER	PPL-DATE	1	42
14	HOLLY CHENILLE JUMPER	PPL-DATE	1	42
15	CHARLOTTE CASHMERE JUMPER	GRY-GREY MARL	1	39.2

<tbody>
</tbody>

Still trying to figure this one out, please can you advise?

I started off in Column E (Value column) by using =LARGE(IF('1924W'!$M:$M='Womens Knitwear (2)'!$C$3,'1924W'!$AB:$AB),A6) to gather the top 15 values based on criteria (c3)

Next in column C (Colour) I have used =INDEX('1924W'!A:V,MATCH(1,('1924W'!M:M=C$3)*('1924W'!AB:AB='Womens Knitwear (2)'!E6),0),16) This matches the colour of an item to the sales value in column E, still based on criteria C3.

In column B I use =INDEX('1924W'!A:V,MATCH(1,('1924W'!M:M=C$3)*('1924W'!AB:AB='Womens Knitwear (2)'!E6),0),4) Similar to above, this matches the name of the item to the sales value, based on criteria C3.

The problem I am having is that Column B will tend to have names repeating because there are items with same name, so I somehow need column C to remove duplicate colour but only where an item name in column B is repeated.

AND

I only want column B to repeat the item name the true amount of times. In the table above you can see an item repeated 4 times because it is basing its criteria on things that aren't unique enough. It should only be twice in this example

What can I add / do differently to get the results I need? Please add into my formula or rewrite

 

[Fluff]

Without being able to see your data, or your criteria, I've no idea.
Also as rows 5 to 8 are identical, how do you determine that they should only appear twice.