Find repeat numbers in rows from previous row

[Terry461]

Hello. I need a Pull-Down formula to find Repeat numbers in Rows
from the Previous Row (above) and display them in a Cell
across to to the Right as I pull down the formula to check
the remaining rows.

Sample Data.
====================
3 10 12 16 33 47
8 27 30 41 45 49
17 22 30 32 40 46
11 22 26 29 46 47
9 10 21 28 35 43
2 5 18 23 29 47
5 17 21 29 41 43
16 19 32 34 48 49
5 21 30 40 46 49
2 4 12 24 30 49
====================

 

[jasonb75]

Is this what you need?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	3	10	12	16	33	47
3	8	27	30	41	45	49
4	17	22	30	32	40	46		30
5	11	22	26	29	46	47		22	46
6	9	10	21	28	35	43
7	2	5	18	23	29	47
8	5	17	21	29	41	43		5	29
9	16	19	32	34	48	49
10	5	21	30	40	46	49		49
11	2	4	12	24	30	49		30	49
Sheet1

Cell Formulas
Range	Formula
H3:M11	H3	=IFERROR(SMALL(IF(ISNUMBER(MATCH($A3:$F3,$A2:$F2,0)),$A3:$F3),COLUMNS($H3:H3)),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

 

[Terry461]

Is this what you need?

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	3	10	12	16	33	47
3	8	27	30	41	45	49
4	17	22	30	32	40	46		30
5	11	22	26	29	46	47		22	46
6	9	10	21	28	35	43
7	2	5	18	23	29	47
8	5	17	21	29	41	43		5	29
9	16	19	32	34	48	49
10	5	21	30	40	46	49		49
11	2	4	12	24	30	49		30	49
Sheet1

Cell Formulas
Range	Formula
H3:M11	H3	=IFERROR(SMALL(IF(ISNUMBER(MATCH($A3:$F3,$A2:$F2,0)),$A3:$F3),COLUMNS($H3:H3)),"")
Press CTRL+SHIFT+ENTER to enter array formulas.

Hi jasonb75

That worked fine. Many thanks!

 

[Peter_SSs]

If you didn't need the results left-aligned like that you could use a simpler, non-array formula like this

23 03 05.xlsm
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	3	10	12	16	33	47
3	8	27	30	41	45	49
4	17	22	30	32	40	46				30
5	11	22	26	29	46	47			22			46
6	9	10	21	28	35	43
7	2	5	18	23	29	47
8	5	17	21	29	41	43		5			29
9	16	19	32	34	48	49
10	5	21	30	40	46	49							49
11	2	4	12	24	30	49						30	49
Sheet2 (2)

Cell Formulas
Range	Formula
H3:M11	H3	=IF(ISNUMBER(MATCH(A3,$A2:$F2,0)),A3,"")

 

[Phuoc]

Or try this

Book1
	A	B	C	D	E	F	G	H	I	J	K	L	M
2	3	10	12	16	33	47
3	8	27	30	41	45	49
4	17	22	30	32	40	46				30
5	11	22	26	29	46	47			22			46
6	9	10	21	28	35	43
7	2	5	18	23	29	47
8	5	17	21	29	41	43		5			29
9	16	19	32	34	48	49
10	5	21	30	40	46	49							49
11	2	4	12	24	30	49						30	49
Sheet1

Cell Formulas
Range	Formula
H3:M11	H3	=IF(COUNTIF($A2:$F2,A3),A3,"")