FILTER Formula

[JTL9161]

I will apologize right now if my explanation is not detailed enough. I think I want to use the =FILTER command but not sure.

I have approximately 20 rows with each with 10 columns of data. Another column is added weekly. The data in each line is random but is from a list of 25 choices. I am looking to create another listing (using FILTER?) that will show the remaining choices left. Meaning every line has 25 items to choose from so if there have been 10 choices so far, I want a listing to show the remaining 15 choices. Then when column 11 data is added that item is removed from the list and now, I am showing 14.

I am guessing the remaining listing needs to be a separate table.

Thank you,
James

 

[JamesCanale]

MrExcelPlayground14.xlsx
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R
1		Col 1	Col 2	Col 3	Col 4	Col 5	Col 6	Col 7	Col 8	Col 9	Col 10
2	1	S	C	I	U	T	P	H	X	A	Y
3	2	B	V	I	H	D	W	M	A	Y	X
4	3	U	B	V	P	I	M	J	C	H	N
5	4	K	F	S	X	Q	D	M	H	L	A
6	5	I	L	O	T	M	P	A	Q	N	C
7	6	B	A	U	S	T	G	P	V	C	Q
8	7	S	C	I	U	T	P	H	X	A	Y
9	8	B	V	I	H	D	W	M	A	Y	X
10	9	U	B	V	P	I	M	J	C	H	N
11	10	K	F	S	X	Q	D	M	H	L	A
12	11	I	L	O	T	M	P	A	Q	N	C
13	12	S	C	I	U	T	P	H	X	A	Y
14	13	B	V	I	H	D	W	M	A	Y	X
15	14	S	C	I	U	T	P	H	X	A	Y
16	15	S	C	I	U	T	P	H	X	A	Y
17	16	B	V	I	H	D	W	M	A	Y	X
18	17	U	B	V	P	I	M	J	C	H	N
19	18	K	F	S	X	Q	D	M	H	L	A
20	19	I	L	O	T	M	P	A	Q	N	C
21	20	B	A	U	S	T	G	P	V	C	Q
22
23
24	Set		Remaining
25	A		1	B	D	E	F	G	J	K	L	M	N	O	Q	R	V	W
26	B		2	C	E	F	G	J	K	L	N	O	P	Q	R	S	T	U
27	C		3	A	D	E	F	G	K	L	O	Q	R	S	T	W	X	Y
28	D		4	B	C	E	G	I	J	N	O	P	R	T	U	V	W	Y
29	E		5	B	D	E	F	G	H	J	K	R	S	U	V	W	X	Y
30	F		6	D	E	F	H	I	J	K	L	M	N	O	R	W	X	Y
31	G		7	B	D	E	F	G	J	K	L	M	N	O	Q	R	V	W
32	H		8	C	E	F	G	J	K	L	N	O	P	Q	R	S	T	U
33	I		9	A	D	E	F	G	K	L	O	Q	R	S	T	W	X	Y
34	J		10	B	C	E	G	I	J	N	O	P	R	T	U	V	W	Y
35	K		11	B	D	E	F	G	H	J	K	R	S	U	V	W	X	Y
36	L		12	B	D	E	F	G	J	K	L	M	N	O	Q	R	V	W
37	M		13	C	E	F	G	J	K	L	N	O	P	Q	R	S	T	U
38	N		14	B	D	E	F	G	J	K	L	M	N	O	Q	R	V	W
39	O		15	B	D	E	F	G	J	K	L	M	N	O	Q	R	V	W
40	P		16	C	E	F	G	J	K	L	N	O	P	Q	R	S	T	U
41	Q		17	A	D	E	F	G	K	L	O	Q	R	S	T	W	X	Y
42	R		18	B	C	E	G	I	J	N	O	P	R	T	U	V	W	Y
43	S		19	B	D	E	F	G	H	J	K	R	S	U	V	W	X	Y
44	T		20	D	E	F	H	I	J	K	L	M	N	O	R	W	X	Y
45	U
46	V
47	W
48	X
49	Y
Sheet16

Cell Formulas
Range	Formula
D25:R44	D25	=TRANSPOSE(FILTER($A$25:$A$49,ISERROR(MATCH($A$25:$A$49,B2:ZZ2,0))))
Dynamic array formulas.

 

[JTL9161]

Wow. Thanks I will give a try