From slicer selection, populate the selected item to a cell

[FaezMH]

Hi Excel Experts,
Good day everyone.
I have the following table as below. I am inserting a slicer based on column A (ie. BRAND). When I click on a slicer say at brand BB, column A will display all the data for Brand BB. And when I click on Brand DD, it will display the data for brand DD. For each change, how can I have eg. brand "BB" populated in cell C57. Meaning that C57 content will change dynamically each time a select a brand from the slicer. I have tried to use Index/Match but they are not working. Guess I still missing something.

Book1
	A	B	C	D	E	F	G	H	I	J
1	BRAND	MONTH	YEAR	RECEIVED QTY	TEST QTY	REJECT QTY
2	AA	JUL	23	12043	371	1
3	BB	JUL	23	5615	77	0
4	CC	JUL	23	7381	100	0
5	DD	JUL	23	0	0	0
6	EE	JUL	23	0	0	0
7	AA	AUG	23	8071	269	1
8	BB	AUG	23	2018	33	0
9	CC	AUG	23	9905	148	0
10	DD	AUG	23	0	0	0
11	EE	AUG	23	0	0	0
12	AA	SEP	23	5531	469	0
13	BB	SEP	23	1973	38	1
14	CC	SEP	23	3981	51	0
15	DD	SEP	23	0	0	0
16	EE	SEP	23	79	0	0
17	AA	SEP	23	0	0	0
18	BB	SEP	23	6003	51	0
19	CC	SEP	23	0	0	0
20	DD	SEP	23	2868	55	0
21	EE	SEP	23	2444	36	0
22	AA	SEP	23	0	0	0
23	BB	SEP	23	1699	23	1
24	CC	SEP	23	0	0	0
25	DD	OCT	23	7952	391	0
26	EE	OCT	23	4173	72	1
27	AA	OCT	23	5484	84	1
28	BB	OCT	23	0	0	0
29	CC	OCT	23	1582	200	0
30	DD	OCT	23	30	0	0
31	EE	OCT	23	9	0	0
32	AA	OCT	23	0	0	0
33	BB	OCT	23	2718	60	0
34	CC	OCT	23	12	0	0
35	DD	OCT	23	0	0	0
36	EE	OCT	23	0	0	0
37	AA	OCT	23	0	0	0
38	BB	NOV	23	7216	187	0
39	CC	NOV	23	3572	69	0
40	DD	NOV	23	4218	76	0
41	EE	NOV	23	0	0	0
42	AA	NOV	23	3135	227	0
43	BB	NOV	23	16	0	0
44	CC	NOV	23	0	0	0
45	DD	NOV	23	0	0	0
46	EE	NOV	23	2950	47	1
47	AA	NOV	23	5270	70	0
48	BB	NOV	23	0	0	0
49	CC	NOV	23	0	0	0
50	DD	NOV	23	0	0	0
51	EE	NOV	23	1518	161	0
52
53	TOTAL			119466	3365	7
54
55
56			BRAND	Prod_Qty	OQC_Qty	OQC_Rej
57		Example>	BB	119466	3365	7
58
Sheet1

Cell Formulas
Range	Formula
G9	G9	=IF($A2=Slicer_PRODUCT_DATA2, $F2, "")
D53:F53	D53	=SUM(D2:D52)
D57:F57	D57	=SUBTOTAL(9,D$2:D$51)

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
F28:F51	Cell Value	>=1	text	NO
F26:F27	Cell Value	>=1	text	NO
F26:F27	Cell Value	=0	text	NO
F2:F25	Cell Value	>=1	text	NO
F52	Cell Value	>=1	text	NO

Thank you.
MH

 

[shift-del]

Hi

Try this:

Mappe8
	C
56	BRAND
57	BB
Tabelle1

Cell Formulas
Range	Formula
C57	C57	=UNIQUE(FILTER(Tabelle1[BRAND],Tabelle1[Filter]))

 

[FaezMH]

Hi,
Thanks. It doesn't seem to work yet.

Hi

Try this:

Mappe8
	C
56	BRAND
57	BB
Tabelle1

Cell Formulas
Range	Formula
C57	C57	=UNIQUE(FILTER(Tabelle1[BRAND],Tabelle1[Filter]))

 

[shift-del]

Because?

 

[FaezMH]

Hi..

Can I know whether Tabelle1 referring to cell A1:A51? I tried for A1:F51 too and getting the same error as below:

Because?

 

[shift-del]

Tabelle1 is the name of table. Change it to table name you are using.

 

[FaezMH]

Yep,

Tabelle1 is the name of table. Change it to table name you are using.

I tried that before and still getting the same error.

 

[shift-del]

Maybe the comma is not you argument separator.

 

[shuklaankur281190]

Hello, I am new to this forum.

I have a suggestion for you. If you're looking for a slicer, you can find it in either the Pivot Table option or the Table feature.

To convert your data into the Table format, select your data and press Control+T. Then, navigate to the Table tab and click on Insert Slicer. From there, select Brand and you will see the Brand Slicer has been inserted.

 

[FaezMH]

i guess i managed to figure it out

Maybe the comma is not you argument separator.