Excel Formula Help

[ststern45]

Hello,

I have the following values starting in cell A1 through A10
A1 = 0
A2 = 1
A3 = 2
A4 = 3
A5 = 4
A6 = 5
A7 = 6
A8 = 7
A9 = 8
A10 = 9

Starting in Cell A11 I enter the following values:
A11 = 0
A12 = 1
A13 = 8
A14 = 4
A15 = 7
A16 = 2

If I take the values in cell range A11 through A16 and remove the values from A1 through A10

3
5
6
9
0
1
8
4
7
2

Enter the new formula starting in cell B11 going down?

Thank you in advance.

 

[Fluff]

Not entirely clear to me what your expected answer is.
Do you just want to list the values from A1:A10 that are not in A11:A16?

 

[ststern45]

Sorry for the confusion.
The starting list is: 0,1,2,3,4,5,6,7,8,9
If I take the value zero (0) (A11) and remove it from the list in A1 through A10 (0,1,2,3,4,5,6,7,8,9) the new string would be: 1,2,3,4,5,6,7,8,9,0
If I take the value 1 (A12) and remove it, the new list: 2,3,4,5,6,7,8,9,0,1
If I take the value 8 (A13) and remove it, the new list: 2,3,4,5,6,7,9,0,1,8
If I take the value 4 (A14) and remove it, the new list: 2,3,5,6,7,9,0,1,8,4
If I take the value 7 (A15) and remove it, the new list: 2,3,5,6,9,0,1,8,4,7
If I take the value 2 (A16) and remove it, the new list: 3,5,6,9,0,1,8,4,7,2 (most current string)
Hope this explains things better.

 

[Fluff]

Ok, how about

+Fluff 1.xlsm
	A	B
1	0
2	1
3	2
4	3
5	4
6	5
7	6
8	7
9	8
10	9
11	0	3
12	1	5
13	8	6
14	4	9
15	7	0
16	2	1
17		8
18		4
19		7
20		2
21
Master

Cell Formulas
Range	Formula
B11:B20	B11	=IFERROR(AGGREGATE(15,6,$A$1:$A$10/(COUNTIFS($A$11:$A$16,$A$1:$A$10)=0),ROWS(B$11:B11)),INDEX($A$11:$A$16,ROWS(B$11:B11)-4))

 

[ststern45]

Thank you Fluff.
Very much appreciated.

 

[ststern45]

I guess my next question is what if I keep adding values past cell A16. The values would be between 0 through 9)
Thank you again.

 

[Fluff]

How about

=IFERROR(AGGREGATE(15,6,$A$1:$A$10/(COUNTIFS($A$11:$A$20,$A$1:$A$10)=0),ROWS(B$11:B11)),INDEX($A$11:$A$20,ROWS(B$11:B11)-(10-COUNT($A$11:$A$20))))

 

[ststern45]

Thank you again.

 

[Fluff]

You're welcome & thanks for the feedback.