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

<tbody>
[TD="align: center"]4[/TD]
[TD="align: center"]13-Jun[/TD]
[TD="align: center"] 35 [/TD]
[TD="align: center"]12[/TD]
[TD="align: center"] 28 [/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]31[/TD]
[TD="align: center"] 02 [/TD]
[TD="align: center"] 15 [/TD]
[TD="align: center"]09[/TD]
[TD="align: center"] 26 [/TD]
[TD="align: center"] 16 [/TD]
[TD="align: center"]34[/TD]
[TD="align: center"] 17 [/TD]
[TD="align: center"]23[/TD]
[TD="align: center"] 19 [/TD]
[TD="align: center"]22[/TD]
[TD="align: center"] 29 [/TD]
[TD="align: center"]30[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"]20[/TD]
[TD="align: center"] 11 [/TD]
[TD="align: center"] 25 [/TD]
[TD="align: center"]18[/TD]

</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

<tbody>
[TD="align: center"]4[/TD]
[TD="align: center"]13-Jun[/TD]
[TD="align: center"] 16 [/TD]
[TD="align: center"]22[/TD]
[TD="align: center"] 15 [/TD]
[TD="align: center"]23[/TD]
[TD="align: center"] 17 [/TD]
[TD="align: center"] 35 [/TD]
[TD="align: center"] 19 [/TD]
[TD="align: center"]99[/TD]
[TD="align: center"]32[/TD]
[TD="align: center"] 11 [/TD]
[TD="align: center"] 25 [/TD]
[TD="align: center"]78[/TD]
[TD="align: center"] 28 [/TD]
[TD="align: center"]14[/TD]
[TD="align: center"]31[/TD]
[TD="align: center"] 02 [/TD]
[TD="align: center"]100[/TD]
[TD="align: center"] 29 [/TD]
[TD="align: center"]77[/TD]
[TD="align: center"]13[/TD]
[TD="align: center"] 26 [/TD]
[TD="align: center"]34[/TD]

</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

<tbody>
[TD="align: center"]4[/TD]
[TD="align: center"]13-Jun[/TD]
[TD="align: center"] 35 [/TD]
[TD="align: center"]12[/TD]
[TD="align: center"] 28 [/TD]
[TD="align: center"]55[/TD]
[TD="align: center"]01[/TD]
[TD="align: center"]05[/TD]
[TD="align: center"] 15 [/TD]
[TD="align: center"]77[/TD]
[TD="align: center"]30[/TD]
[TD="align: center"] 11 [/TD]
[TD="align: center"] 17 [/TD]
[TD="align: center"] 25 [/TD]
[TD="align: center"] 26 [/TD]
[TD="align: center"]27[/TD]
[TD="align: center"] 16 [/TD]
[TD="align: center"]58[/TD]
[TD="align: center"]40[/TD]
[TD="align: center"]63[/TD]
[TD="align: center"] 29 [/TD]
[TD="align: center"] 19 [/TD]
[TD="align: center"] 02 [/TD]
[TD="align: center"]13[/TD]

</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

<tbody>
[TD="align: center"]4[/TD]
[TD="align: center"]13-Jun[/TD]
[TD="align: center"] 02 [/TD]
[TD="align: center"] 11 [/TD]
[TD="align: center"] 15 [/TD]
[TD="align: center"] 16 [/TD]
[TD="align: center"] 17 [/TD]
[TD="align: center"] 1 9[/TD]
[TD="align: center"] 25 [/TD]
[TD="align: center"] 26 [/TD]
[TD="align: center"] 28 [/TD]
[TD="align: center"] 29 [/TD]
[TD="align: center"] 35 [/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]

</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?