Formula help

[leezhihong]

How to set up a formula in U10:U19 ,make it like P10:P19?

Excel Workbook
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
7	0	1	2	3	4	5	6	7	8	9
8
9												Goal					Formula		How to do?
10	18	15	27	23	17	19	14	26	21	21		27	2				27	2
11	12	24	16	21	23	18	28	20	19	20		28	6				28	6
12	22	12	18	13	26	23	18	24	19	26		26	4	9			26	4
13	22	20	17	27	19	21	19	13	17	26		27	3				27	3
14	11	22	21	21	15	22	19	25	20	25		25	7	9			25	7
15	18	15	14	17	21	27	21	22	23	23		27	5				27	5
16	21	18	21	23	22	16	18	29	18	15		29	7				29	7
17	25	19	27	8	17	26	16	18	23	22		27	2				27	2
18	20	26	20	12	26	24	18	20	16	19		26	1	4			26	1
19	23	24	18	18	25	23	11	18	23	18		25	4				25	4
Sheet1 (2)

 

[leezhihong]

I already solve the formulas in S10:T19.

Excel Workbook
	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U
7	0	1	2	3	4	5	6	7	8	9
8
9												Goal					Formula		How to do?
10	18	15	27	23	17	19	14	26	21	21		27	2				27	2
11	12	24	16	21	23	18	28	20	19	20		28	6				28	6
12	22	12	18	13	26	23	18	24	19	26		26	4	9			26	4
13	22	20	17	27	19	21	19	13	17	26		27	3				27	3
14	11	22	21	21	15	22	19	25	20	25		25	7	9			25	7
15	18	15	14	17	21	27	21	22	23	23		27	5				27	5
16	21	18	21	23	22	16	18	29	18	15		29	7				29	7
17	25	19	27	8	17	26	16	18	23	22		27	2				27	2
18	20	26	20	12	26	24	18	20	16	19		26	1	4			26	1
19	23	24	18	18	25	23	11	18	23	18		25	4				25	4
Sheet1 (2)

 

[baitmaster]

T10, I put:
=MATCH(N10,C10:L10,0)-1

U10, I put
=IF(COUNTIF(C10:L10,N10)>1,MATCH(N10,OFFSET(C10,0,T10+1):L10,0)+T10,"")

 

[leezhihong]

Thank you, baitmaster!