Formula to push digits to the right.

[serge]

Hi,
I'm looking for a formula that will push to the right the digits as they come down from column B, so that the newest digits is on the left and the oldest is on the right.
This will show me how long a digits hasn't been selected, how many time it skip.

Thank you.

 

[serge]

I'm sorry Rick I spoke to fast your formula doesn't stop either !
I'm looking for a formula that will remove the digit from the row when it become drowned in column B.

 

[Phuoc]

Try again:

Book1
	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
3	1		1
4	3		3	1
5	5		5	3	1
6	8		8	5	3	1
7	2		2	8	5	3	1
8	6		6	2	8	5	3	1
9	7		7	6	2	8	5	3	1
10	0		0	7	6	2	8	5	3	1
11	9		9	0	7	6	2	8	5	3	1
12	4		4	9	0	7	6	2	8	5	3	1
13	5		5	4	9	0	7	6	2	8	3	1
14	9		9	5	4	0	7	6	2	8	3	1
15	0		0	9	5	4	7	6	2	8	3	1
16	4		4	0	9	5	7	6	2	8	3	1
Sheet1

Cell Formulas
Range	Formula
D3:D16	D3	=IF($B3="","",B3)
E3:P16	E3	=IFERROR(LOOKUP(2,1/(COUNTIF($D3:D3,$B$3:$B3)=0),$B$3:$B3),"")

 

[serge]

Thank you Phuoc, your formula work fine, thank you this one stop at 10 digits.

 

[Rick Rothstein]

I'm sorry Rick I spoke to fast your formula doesn't stop either !
I'm looking for a formula that will remove the digit from the row when it become drowned in column B.

I do not understand what you are wanting here. What does "become drowned in Column B" mean? It appears (from other replies) that you are looking to stop calculating values at some point, but I am unsure what that point is.