Extract Digits only if match in 3 Ranges, (extract to next empty cell)

[frankyalta]

Hi,

i'm looking for a formula or vba code to extract matched digits from 3 ranges?,i been reading and searching (many examples online) but didn't found something close that can help me.
All digits ranging between 1 to 100
Range LR4:MM4 have 22 digits
Range MV4:NQ4 have 22 digits
Range NZ4:OU4 have 22 digits

In range KS4:LI4 (17 cells) is where i need to get the matched digits but coping/extracting on next empty cell in a row. (starting KS4)


Thanks !!!!!!!!!!!!!!!!!

 

[FDibbins]

Please provide some sample data so we don't have to guess

 

[frankyalta]

Hi Fdibbins,

How do i upload the sample data?

Thanks!

 

[frankyalta]

Bump

 

[frankyalta]

BUMP Please..

 

[frankyalta]

Bump

 

[frankyalta]

bump

 

[FDibbins]

See the link in my signature below, or just copy/paste some data here

 

[frankyalta]

Thanks for your signature Suggestion Mr Dibbins, Thanks to you I learned how to use MrExcel html add-in.

Range #1 - Digits between 1 to 100

Row	LQ	LR	LS	LT	LU	LV	LW	LX	LY	LZ	MA	MB	MC	MD	ME	MF	MG	MH	MI	MJ	MK	ML	MM
4	13-Jun	35	12	28	14	31	02	15	09	26	16	34	17	23	19	22	29	30	32	20	11	25	18

<tbody>
</tbody>

Range #2 - Digits between 1 to 100

Row	MU	MV	MW	MX	MY	MZ	NA	NB	NC	ND	NE	NF	NG	NH	NI	NJ	NK	NL	NM	NN	NO	NP	NQ
4	13-Jun	16	22	15	23	17	35	19	99	32	11	25	78	28	14	31	02	100	29	77	13	26	34

<tbody>
</tbody>

Range #3 - Digits between 1 to 100

Row	NY	NZ	OA	OB	OC	OD	OE	OF	OG	OH	OI	OJ	OK	OL	OM	ON	OO	OP	OQ	OR	OS	OT	OU
4	13-Jun	35	12	28	55	01	05	15	77	30	11	17	25	26	27	16	58	40	63	29	19	02	13

<tbody>
</tbody>

Desired Output -Numbers Extracted (Triplicated) in 3 ranges

Row	KR	KS	KT	KU	KV	KW	KX	KY	KZ	LA	LB	LC	LD	LE	LF	LG	LH	LI
4	13-Jun	02	11	15	16	17	19	25	26	28	29	35

<tbody>
</tbody>

Please i need a Formula or VBA Code to Extract Digits Only if Matches in Range 1, Range 2 and Range 3 and copy on next empty cell in a row starting in cell KS4 to LI4 as displayed.

Thanks

 

[FDibbins]

none of your "desired" criteria matches anything in your actual data - how do you arrive at your answers?