#### frankyalta

##### New Member

- Joined
- Nov 8, 2015

- Messages
- 29

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

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

Last edited: