Incrementing cell address inside Filter function

[KarthickDijo]

Hi All,

Could anyone help me out in achieving the same output as showed in the output. Or help me out in incrementing the cell address as below.

=FILTER(Sheet1!C:C,((Sheet1!G:G=(MINIFS(Sheet1!G:G,Sheet1!J:J,Sheet2!K3)))*(Sheet1!J:J=Sheet2!K3))) ---> This will give a result of two
=FILTER(Sheet1!C:C,((Sheet1!G:G=(MINIFS(Sheet1!G:G,Sheet1!J:J,Sheet2!K4)))*(Sheet1!J:J=Sheet2!K4))) ---> This will give a result of four
=FILTER(Sheet1!C:C,((Sheet1!G:G=(MINIFS(Sheet1!G:G,Sheet1!J:J,Sheet2!K5)))*(Sheet1!J:J=Sheet2!K5))) ---> This will give a result of three

Likewise is there any option to auto increment the cell address.

Thanks in advance !!

Book14.xlsx
	J	K	L	M	N	O	P	Q	R	S	T	U	V
1		ss	ddd				SKU	Option 1 Name	Option 1 Value	Value 1 Norm	USD Unit Wholesale Price	Option Image
2		Concat	rr				ModifierItemID	ModifierListName	Delete	ModifierItemName	BasePrice	PhotoName	ModifierListKey
3		01, 02	3.44				POP049-01
4		Blue, Gray, Khaki, Red	23.79				POP049-02
5		Blue, Green, Red	13.17				ASJP018-B3-S
6		Blue, Dark Gray, Gray, Pink, White	7.75				ASJP018-G3-S
7		Apricot	4.69				ASJP018-K1-S
8		01	3.73				ASJP018-R1-S
9		01, 02, 03, 04, 05, 06, 07	5.19				STC185-B3-S
10		White	3.74				STC185-G1-S
11		Blue, Green	14.29				STC185-R1-S
12		Black, Red	3.25
13		Pink	3.74
14		Black	3.13
15		Black, Green, Khaki, Red	11.88
16		Red	3.13
17		Black, Gray	8.45
18		Apricot, Black, White	12.74
19		Black, Gray, White	5.85
20		Green	3.74
21		Blue, Dark Blue, Leopard, Multicolor, Purple	9.99
22		Light Blue	12.35
23		Blue, Dark Gray	13.17
24		Leopard	3.89
25		Apricot, Beige, Black, Coffee, Green, Khaki, Light Blue, Multicolor, Orange, Wine Red	16.25
26		Army Green, Dark Gray, Khaki, Light Gray, Wine Red	24.69
27		Apricot, Blue, Gray, Green, Purple	26.39
28		Apricot, Army Green, Black, Brown, Gray, Green, Navy, Pink, White, Wine Red	14.04
29		Silver	3.25
30		Apricot, Green, Pink	21.19
31		Coffee	13.39
32		Black, Blue, Dark Gray	13.17
33		Coffee, Dark Gray, Gray	10.66
34		Blue, Dark Gray, Orange, Rose Red	12.81
35		Black, Green, Khaki, Light Blue, Navy, Pink, White, Wine Red	16.64
36		Black, Gold, Pink, Purple, Red	8.45
37		Blue, Khaki, Yellow	19.3
38		Camel	15.34
39		Brown	3.73
40		Black, Green, Yellow	15.34
41		Orange	4.69
42		Blue	3.73
43		Green, Orange, White	17.54
44		B3-EST011, B3-EST018B, G1-EST011, G1-EST018B	16.01
45		Apricot, Black, Brown, Burgundy, Lavender	28.67
46		Gray, Hallmark, Santa	16.94
47		Blue, Pink, White	7.79
48		Black, Blue, Orange	24.69
49		Black, Blue, Pink, Yellow	17.94
50		Black, Blue, Red, Rose Red, White	13.74
51		Black, Blue	13.11
52		Apricot, Black, Blue, Khaki, Orange, White	28.59
53		Dark Gray, Gray, White	11.11
54		01, 02, 03, 04, 05, 06	3.74
55		Army Green, Black, Camouflage	7.79
56		Multicolor	3.73
57		Brown, Dark Gray, Gray, Green, Wine Red	19.24
58		01, 02, 03, 04, 05, 06, 07, 08, 09, 10	3.25
59		Apricot, Black, Gray, Orange, Purple	18.72
60		Blue, Green, Wine Red	18.89
61		Black, Gray, Khaki, Pink, White	11.24
62		Black, Blue, Dark Blue, Dark Gray, Light Blue	16.25
63		Black, Brown, Green, Multicolor	14.13
64		01, 02, 03, 04	3.74
65		01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12, 13, 14	3.89
66		Blue, Gray, Khaki	15.06
67		Blue, Brown, Dark Brown, Dark Green, Green, Navy, Orange, Red, Sky Blue, Yellow	39.58
68		Blue, Light purple	21.24
69		Black, Brown	4.56
70		Gold, Multicolor	4.99
71		Blue, Dark Gray, Green, Red	14.99
72		Gray	9.09
73		Light Blue, Orange, Pink, Yellow	25.09
74		Navy	3.89
75		Green, Orange, Pink	17.16
76		01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11, 12	3.25
77		Khaki	9.75
78		Blue, Wine Red	18.88
79		Black, Green, Orange, Rose Red	28.34
80		Apricot, Beige, Black, Brown, Khaki	19.49
81		Apricot, Beige, Black, Brown, Gray, Khaki, Pink	16.89
82		Gray, Pink	4.99
83		Black, Red, Yellow	3.89
84		Black, Green, Light green, Red	16.94
85		Purple	10.39
86		White, Yellow	3.89
87		Black, Blue, Green, White	11.69
88		Apricot, Black, Brown, Dark Blue, Gray	25.03
89		Black, Wine Red, Yellow	18.59
Sheet2

Cell Formulas
Range	Formula
K2:K1617	K2	=UNIQUE(Sheet1!J:J)
P3:P4	P3	=FILTER(Sheet1!C:C,((Sheet1!G:G=(MINIFS(Sheet1!G:G,Sheet1!J:J,Sheet2!K3)))*(Sheet1!J:J=Sheet2!K3)))
P5:P8	P5	=FILTER(Sheet1!C:C,((Sheet1!G:G=(MINIFS(Sheet1!G:G,Sheet1!J:J,Sheet2!K4)))*(Sheet1!J:J=Sheet2!K4)))
P9:P11	P9	=FILTER(Sheet1!C:C,((Sheet1!G:G=(MINIFS(Sheet1!G:G,Sheet1!J:J,Sheet2!K5)))*(Sheet1!J:J=Sheet2!K5)))
L3:L89	L3	=MINIFS(Sheet1!G:G,Sheet1!J:J,Sheet2!K3)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
P1	Cell Value	duplicates	text	NO

 

[KarthickDijo]

In that case can you also post the data from sheet1.

It's bit confidential data. Anyways thanks for trying to help me out. Let me mark the thread as solved

 

[Fluff]

I only need to see the data from columns C,G & J, not the whole sheet.

 

[KarthickDijo]

Book14.xlsx
	C	D	E	F	G	H	I	J
1	SKU	Option 1 Name	Option 1 Value	Value 1 Norm	USD Unit Wholesale Price	Option Image	Countif	Concat
2	ACC1210-01	Color	01	01	$7.49		2	01, 02
3	ACC1210-02	Color	02	02	$7.49		2	01, 02
4	MMY024-B3-S	Color	Blue	Blue	$24.69		4	Blue, Gray, Khaki, Red
5	MMY024-G3-S	Color	Gray	Gray	$24.69		4	Blue, Gray, Khaki, Red
6	MMY024-K1-S	Color	Khaki	Khaki	$24.69		4	Blue, Gray, Khaki, Red
7	MMY024-R1-S	Color	Red	Red	$24.69		4	Blue, Gray, Khaki, Red
8	STC185C41-B3-FA041-S	Color	Blue	Blue	$16.02		3	Blue, Green, Red
9	STC185C41-G1-FA041-S	Color	Green	Green	$16.02		3	Blue, Green, Red
10	STC185C41-R1-FA041-S	Color	Red	Red	$16.02		3	Blue, Green, Red
11	STC210C27-B3-F001W-S	Color	Blue	Blue	$11.05		5	Blue, Dark Gray, Gray, Pink, White
12	STC210C27-D2-F001W-S	Color	Dark Gray	Dark Gray	$11.05		5	Blue, Dark Gray, Gray, Pink, White
13	STC210C27-G3-F001B-S	Color	Gray	Gray	$11.05		5	Blue, Dark Gray, Gray, Pink, White
14	STC210C27-P1-F001W-S	Color	Pink	Pink	$11.05		5	Blue, Dark Gray, Gray, Pink, White
15	STC210C27-W1-F001B-S	Color	White	White	$11.05		5	Blue, Dark Gray, Gray, Pink, White
16	LQ020-A1-S	Color	Apricot	Apricot	$14.95		1	Apricot
17	SPEA785-01	Color	01	01	$3.89		1	01
18	ZZKF047-01	Color	01	01	$11.69		7	01, 02, 03, 04, 05, 06, 07
19	ZZKF047-02	Color	02	02	$11.69		7	01, 02, 03, 04, 05, 06, 07
20	ZZKF047-03	Color	03	03	$11.69		7	01, 02, 03, 04, 05, 06, 07
21	ZZKF047-04	Color	04	04	$11.69		7	01, 02, 03, 04, 05, 06, 07
22	ZZKF047-05	Color	05	05	$11.69		7	01, 02, 03, 04, 05, 06, 07
23	ZZKF047-06	Color	06	06	$11.69		7	01, 02, 03, 04, 05, 06, 07
24	ZZKF047-07	Color	07	07	$11.69		7	01, 02, 03, 04, 05, 06, 07
25	XC576-W1-S	Color	White	White	$11.35		1	White
26	ZXH004-B3-90	Color	Blue	Blue	$14.29		2	Blue, Green
27	ZXH004-G1-90	Color	Green	Green	$14.29		2	Blue, Green
28	YO3235-B1-XL	Color	Black	Black	$15.99		2	Black, Red
29	YO3235-R1-XL	Color	Red	Red	$15.99		2	Black, Red
30	LS012-P1-S	Color	Pink	Pink	$27.29		1	Pink
31	SP001-01	Color	01	01	$3.89		2	01, 02
32	SP001-02	Color	02	02	$3.89		2	01, 02
33	TOPW874-B1-S	Color	Black	Black	$12.25		1	Black
34	DY019-B1-S	Color	Black	Black	$27.69		4	Black, Green, Khaki, Red
35	DY019-G1-S	Color	Green	Green	$27.69		4	Black, Green, Khaki, Red
36	DY019-K1-S	Color	Khaki	Khaki	$27.69		4	Black, Green, Khaki, Red
37	DY019-R1-S	Color	Red	Red	$27.69		4	Black, Green, Khaki, Red
38	XC1238-R1-S	Color	Red	Red	$20.69		1	Red
39	YO2783-B1-S	Color	Black	Black	$13.65		2	Black, Gray
40	YO2783-G3-S	Color	Gray	Gray	$13.65		2	Black, Gray
41	DRSW882-B1-1XL	Color	Black	Black	$24.31		1	Black
42	YYM003-A1-S	Color	Apricot	Apricot	$38.35		3	Apricot, Black, White
43	YYM003-B1-S	Color	Black	Black	$38.35		3	Apricot, Black, White
44	YYM003-W1-S	Color	White	White	$38.35		3	Apricot, Black, White
45	JYYS062-B1-S	Color	Black	Black	$27.29		3	Black, Gray, White
46	JYYS062-G3-S	Color	Gray	Gray	$27.29		3	Black, Gray, White
47	JYYS062-W1-S	Color	White	White	$27.29		3	Black, Gray, White
48	YS003-B1-XL	Color	Black	Black	$11.05		2	Black, Gray
49	YS003-G3-XL	Color	Gray	Gray	$11.05		2	Black, Gray
50	TOPW1929-G1-S	Color	Green	Green	$12.25		1	Green
51	STC084C-B3-T625-S	Color	Blue	Blue	$13.17		5	Blue, Dark Blue, Leopard, Multicolor, Purple
52	STC084C-D5-T625-S	Color	Dark Blue	Dark Blue	$13.17		5	Blue, Dark Blue, Leopard, Multicolor, Purple
53	STC084C-L3-S	Color	Leopard	Leopard	$13.17		5	Blue, Dark Blue, Leopard, Multicolor, Purple
54	STC084C-M1-T625-S	Color	Multi-colored	Multicolor	$13.17		5	Blue, Dark Blue, Leopard, Multicolor, Purple
55	STC084C-P2-T625-S	Color	Purple	Purple	$13.17		5	Blue, Dark Blue, Leopard, Multicolor, Purple
56	QTN016-L1-S	Color	Light Blue	Light Blue	$24.31		1	Light Blue
57	STC082C2-B3-T427-S	Color	Blue	Blue	$13.17		2	Blue, Dark Gray
58	STC082C2-D2-T427-S	Color	Dark Gray	Dark Gray	$13.17		2	Blue, Dark Gray
59	STC210P16-B3-ANI004W-2XL	Color	Blue	Blue	$12.25		5	Blue, Dark Gray, Gray, Pink, White
60	STC210P16-D2-ANI004W-2XL	Color	Dark Gray	Dark Gray	$12.25		5	Blue, Dark Gray, Gray, Pink, White
61	STC210P16-G3-ANI004B-2XL	Color	Gray	Gray	$12.25		5	Blue, Dark Gray, Gray, Pink, White
62	STC210P16-P1-ANI004W-2XL	Color	Pink	Pink	$12.25		5	Blue, Dark Gray, Gray, Pink, White
63	STC210P16-W1-ANI004B-2XL	Color	White	White	$12.25		5	Blue, Dark Gray, Gray, Pink, White
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
C1:C15805	Cell Value	duplicates	text	NO

Cells with Data Validation
Cell	Allow	Criteria
C2:C63	Text length	<=191
E2:F15805	Text length	<=180
G2:G15805	Whole number	>0

 

[Fluff]

Thanks for that.
The formula works for me

Fluff.xlsm
	K	L				P	Q
1	ss	ddd				SKU	Option 1 Name
2	Concat	0				ModifierItemID	ModifierListName
3	01, 02	3.89				SP001-01
4	Blue, Gray, Khaki, Red	24.69				SP001-02
5	Blue, Green, Red	16.02				MMY024-B3-S
6	Blue, Dark Gray, Gray, Pink, White	11.05				MMY024-G3-S
7	Apricot	14.95				MMY024-K1-S
8	1	3.89				MMY024-R1-S
9	01, 02, 03, 04, 05, 06, 07	11.69				STC185C41-B3-FA041-S
10	White	11.35				STC185C41-G1-FA041-S
11	Blue, Green	14.29				STC185C41-R1-FA041-S
12	Black, Red	15.99
13	Pink	27.29
14	Black	12.25
15	Black, Green, Khaki, Red	27.69
16	Red	20.69
17	Black, Gray	11.05
18	Apricot, Black, White	38.35
19	Black, Gray, White	27.29
20	Green	12.25
21	Blue, Dark Blue, Leopard, Multicolor, Purple	13.17
22	Light Blue	24.31
23	Blue, Dark Gray	13.17
24	0	0
Update

Cell Formulas
Range	Formula
K2:K24	K2	=UNIQUE(Sheet1!J:J)
L2:L24	L2	=MINIFS(Sheet1!G:G,Sheet1!J:J,K2#)
P3:P11	P3	=DROP(REDUCE("",K3:K5,LAMBDA(a,b,VSTACK(a,FILTER(Sheet1!C2:C1000,((Sheet1!G2:G1000=(MINIFS(Sheet1!G2:G1000,Sheet1!J2:J1000,b)))*(Sheet1!J2:J1000=b)))))),1)
Dynamic array formulas.

Did you make any changes to the formula I suggested?

 

[KarthickDijo]

Thanks for that.
The formula works for me

Fluff.xlsm
	K	L				P	Q
1	ss	ddd				SKU	Option 1 Name
2	Concat	0				ModifierItemID	ModifierListName
3	01, 02	3.89				SP001-01
4	Blue, Gray, Khaki, Red	24.69				SP001-02
5	Blue, Green, Red	16.02				MMY024-B3-S
6	Blue, Dark Gray, Gray, Pink, White	11.05				MMY024-G3-S
7	Apricot	14.95				MMY024-K1-S
8	1	3.89				MMY024-R1-S
9	01, 02, 03, 04, 05, 06, 07	11.69				STC185C41-B3-FA041-S
10	White	11.35				STC185C41-G1-FA041-S
11	Blue, Green	14.29				STC185C41-R1-FA041-S
12	Black, Red	15.99
13	Pink	27.29
14	Black	12.25
15	Black, Green, Khaki, Red	27.69
16	Red	20.69
17	Black, Gray	11.05
18	Apricot, Black, White	38.35
19	Black, Gray, White	27.29
20	Green	12.25
21	Blue, Dark Blue, Leopard, Multicolor, Purple	13.17
22	Light Blue	24.31
23	Blue, Dark Gray	13.17
24	0	0
Update

Cell Formulas
Range	Formula
K2:K24	K2	=UNIQUE(Sheet1!J:J)
L2:L24	L2	=MINIFS(Sheet1!G:G,Sheet1!J:J,K2#)
P3:P11	P3	=DROP(REDUCE("",K3:K5,LAMBDA(a,b,VSTACK(a,FILTER(Sheet1!C2:C1000,((Sheet1!G2:G1000=(MINIFS(Sheet1!G2:G1000,Sheet1!J2:J1000,b)))*(Sheet1!J2:J1000=b)))))),1)
Dynamic array formulas.

Did you make any changes to the formula I sugges

Thanks for that.
The formula works for me

Fluff.xlsm
	K	L				P	Q
1	ss	ddd				SKU	Option 1 Name
2	Concat	0				ModifierItemID	ModifierListName
3	01, 02	3.89				SP001-01
4	Blue, Gray, Khaki, Red	24.69				SP001-02
5	Blue, Green, Red	16.02				MMY024-B3-S
6	Blue, Dark Gray, Gray, Pink, White	11.05				MMY024-G3-S
7	Apricot	14.95				MMY024-K1-S
8	1	3.89				MMY024-R1-S
9	01, 02, 03, 04, 05, 06, 07	11.69				STC185C41-B3-FA041-S
10	White	11.35				STC185C41-G1-FA041-S
11	Blue, Green	14.29				STC185C41-R1-FA041-S
12	Black, Red	15.99
13	Pink	27.29
14	Black	12.25
15	Black, Green, Khaki, Red	27.69
16	Red	20.69
17	Black, Gray	11.05
18	Apricot, Black, White	38.35
19	Black, Gray, White	27.29
20	Green	12.25
21	Blue, Dark Blue, Leopard, Multicolor, Purple	13.17
22	Light Blue	24.31
23	Blue, Dark Gray	13.17
24	0	0
Update

Cell Formulas
Range	Formula
K2:K24	K2	=UNIQUE(Sheet1!J:J)
L2:L24	L2	=MINIFS(Sheet1!G:G,Sheet1!J:J,K2#)
P3:P11	P3	=DROP(REDUCE("",K3:K5,LAMBDA(a,b,VSTACK(a,FILTER(Sheet1!C2:C1000,((Sheet1!G2:G1000=(MINIFS(Sheet1!G2:G1000,Sheet1!J2:J1000,b)))*(Sheet1!J2:J1000=b)))))),1)
Dynamic array formulas.

Did you make any changes to the formula I suggested?

No i didn't.. how to fill down the data in P column??

 

[Fluff]

It already does that.

 

[KarthickDijo]

It already does that.

Sorry am travelling right now will check later and update the result. Will it bring all the combination (n number) of data in Sheet1 C column related to the sheet1 concat column ???

 

[Fluff]

It will do exactly what you originally chowed without having to use separate formulas.

 

[Fluff]

If you want to run the formula in col P for all values in col K, then you can use this, although you will need to change the formula in col K as shown.

Fluff.xlsm
	K	L				P
1	ss	ddd				SKU
2	01, 02	3.89				ModifierItemID
3	Blue, Gray, Khaki, Red	24.69				SP001-01
4	Blue, Green, Red	16.02				SP001-02
5	Blue, Dark Gray, Gray, Pink, White	11.05				MMY024-B3-S
6	Apricot	14.95				MMY024-G3-S
7	1	3.89				MMY024-K1-S
8	01, 02, 03, 04, 05, 06, 07	11.69				MMY024-R1-S
9	White	11.35				STC185C41-B3-FA041-S
10	Blue, Green	14.29				STC185C41-G1-FA041-S
11	Black, Red	15.99				STC185C41-R1-FA041-S
12	Pink	27.29				STC210C27-B3-F001W-S
13	Black	12.25				STC210C27-D2-F001W-S
14	Black, Green, Khaki, Red	27.69				STC210C27-G3-F001B-S
15	Red	20.69				STC210C27-P1-F001W-S
16	Black, Gray	11.05				STC210C27-W1-F001B-S
17	Apricot, Black, White	38.35				LQ020-A1-S
18	Black, Gray, White	27.29				SPEA785-01
19	Green	12.25				ZZKF047-01
20	Blue, Dark Blue, Leopard, Multicolor, Purple	13.17				ZZKF047-02
21	Light Blue	24.31				ZZKF047-03
22	Blue, Dark Gray	13.17				ZZKF047-04
23						ZZKF047-05
24						ZZKF047-06
25						ZZKF047-07
26						XC576-W1-S
27						ZXH004-B3-90
28						ZXH004-G1-90
29						YO3235-B1-XL
30						YO3235-R1-XL
31						LS012-P1-S
32						TOPW874-B1-S
33						DY019-B1-S
34						DY019-G1-S
35						DY019-K1-S
36						DY019-R1-S
37						XC1238-R1-S
38						YS003-B1-XL
39						YS003-G3-XL
40						YYM003-A1-S
41						YYM003-B1-S
42						YYM003-W1-S
43						JYYS062-B1-S
44						JYYS062-G3-S
45						JYYS062-W1-S
46						TOPW1929-G1-S
47						STC084C-B3-T625-S
48						STC084C-D5-T625-S
49						STC084C-L3-S
50						STC084C-M1-T625-S
51						STC084C-P2-T625-S
52						QTN016-L1-S
53						STC082C2-B3-T427-S
54						STC082C2-D2-T427-S
55
Update

Cell Formulas
Range	Formula
K2:K22	K2	=UNIQUE(FILTER(Sheet1!J2:J10000,Sheet1!J2:J10000<>""))
L2:L22	L2	=MINIFS(Sheet1!G:G,Sheet1!J:J,K2#)
P3:P54	P3	=DROP(REDUCE("",K2#,LAMBDA(a,b,VSTACK(a,FILTER(Sheet1!C2:C10000,((Sheet1!G2:G10000=(MINIFS(Sheet1!G2:G10000,Sheet1!J2:J10000,b)))*(Sheet1!J2:J10000=b)))))),1)
Dynamic array formulas.

 

[KarthickDijo]

If you want to run the formula in col P for all values in col K, then you can use this, although you will need to change the formula in col K as shown.

Fluff.xlsm
	K	L				P
1	ss	ddd				SKU
2	01, 02	3.89				ModifierItemID
3	Blue, Gray, Khaki, Red	24.69				SP001-01
4	Blue, Green, Red	16.02				SP001-02
5	Blue, Dark Gray, Gray, Pink, White	11.05				MMY024-B3-S
6	Apricot	14.95				MMY024-G3-S
7	1	3.89				MMY024-K1-S
8	01, 02, 03, 04, 05, 06, 07	11.69				MMY024-R1-S
9	White	11.35				STC185C41-B3-FA041-S
10	Blue, Green	14.29				STC185C41-G1-FA041-S
11	Black, Red	15.99				STC185C41-R1-FA041-S
12	Pink	27.29				STC210C27-B3-F001W-S
13	Black	12.25				STC210C27-D2-F001W-S
14	Black, Green, Khaki, Red	27.69				STC210C27-G3-F001B-S
15	Red	20.69				STC210C27-P1-F001W-S
16	Black, Gray	11.05				STC210C27-W1-F001B-S
17	Apricot, Black, White	38.35				LQ020-A1-S
18	Black, Gray, White	27.29				SPEA785-01
19	Green	12.25				ZZKF047-01
20	Blue, Dark Blue, Leopard, Multicolor, Purple	13.17				ZZKF047-02
21	Light Blue	24.31				ZZKF047-03
22	Blue, Dark Gray	13.17				ZZKF047-04
23						ZZKF047-05
24						ZZKF047-06
25						ZZKF047-07
26						XC576-W1-S
27						ZXH004-B3-90
28						ZXH004-G1-90
29						YO3235-B1-XL
30						YO3235-R1-XL
31						LS012-P1-S
32						TOPW874-B1-S
33						DY019-B1-S
34						DY019-G1-S
35						DY019-K1-S
36						DY019-R1-S
37						XC1238-R1-S
38						YS003-B1-XL
39						YS003-G3-XL
40						YYM003-A1-S
41						YYM003-B1-S
42						YYM003-W1-S
43						JYYS062-B1-S
44						JYYS062-G3-S
45						JYYS062-W1-S
46						TOPW1929-G1-S
47						STC084C-B3-T625-S
48						STC084C-D5-T625-S
49						STC084C-L3-S
50						STC084C-M1-T625-S
51						STC084C-P2-T625-S
52						QTN016-L1-S
53						STC082C2-B3-T427-S
54						STC082C2-D2-T427-S
55
Update

Cell Formulas
Range	Formula
K2:K22	K2	=UNIQUE(FILTER(Sheet1!J2:J10000,Sheet1!J2:J10000<>""))
L2:L22	L2	=MINIFS(Sheet1!G:G,Sheet1!J:J,K2#)
P3:P54	P3	=DROP(REDUCE("",K2#,LAMBDA(a,b,VSTACK(a,FILTER(Sheet1!C2:C10000,((Sheet1!G2:G10000=(MINIFS(Sheet1!G2:G10000,Sheet1!J2:J10000,b)))*(Sheet1!J2:J10000=b)))))),1)
Dynamic array formulas.

Still am getting the #CALC error only..

Book14.xlsx
	N	O	P	Q	R	S	T	U	V	W	X
1	New1	New2			SKU	Option 1 Name	Option 1 Value	Value 1 Norm	USD Unit Wholesale Price	Option Image
2	01, 02	0			ModifierItemID	ModifierListName	Delete	ModifierItemName	BasePrice	PhotoName	ModifierListKey
3	Blue, Gray, Khaki, Red	3.44			#CALC!	#CALC!
4	Blue, Green, Red	23.79
5	Blue, Dark Gray, Gray, Pink, White	13.17
6	Apricot	7.75
7	01	4.69
8	01, 02, 03, 04, 05, 06, 07	3.73
9	White	5.19
10	Blue, Green	3.74
11	Black, Red	14.29
12	Pink	3.25
13	Black	3.74
14	Black, Green, Khaki, Red	3.13
15	Red	11.88
16	Black, Gray	3.13
17	Apricot, Black, White	8.45
18	Black, Gray, White	12.74
19	Green	5.85
20	Blue, Dark Blue, Leopard, Multicolor, Purple	3.74
21	Light Blue	9.99
22	Blue, Dark Gray	12.35
23	Leopard	13.17
Sheet2

Cell Formulas
Range	Formula
N2:N1145	N2	=UNIQUE(FILTER(Sheet1!J2:J10000,Sheet1!J2:J10000<>""))
O2:O1617	O2	=MINIFS(Sheet1!G:G,Sheet1!J:J,K2#)
R3	R3	=DROP(REDUCE("",K2#,LAMBDA(a,b,VSTACK(a,FILTER(Sheet1!C2:C10000,((Sheet1!G2:G10000=(MINIFS(Sheet1!G2:G10000,Sheet1!J2:J10000,b)))*(Sheet1!J2:J10000=b)))))),1)
S3	S3	=DROP(REDUCE("",K2#,LAMBDA(a,b,VSTACK(a,FILTER(Sheet1!C2:C10000,((Sheet1!G2:G10000=(MINIFS(Sheet1!G2:G10000,Sheet1!J2:J10000,b)))*(Sheet1!J2:J10000=b)))))),1)
Dynamic array formulas.

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
R1	Cell Value	duplicates	text	NO