Extract Duplicates to create another list.

J

J.W. Aldridge

I have a string of data (numbers) starting in B6:B10000 and another in
I6:I10000..

I need a list of all numbers that were found in both ranges in S6 (no
spaces).
 
O

Otto Moehrbach

JW
S6 is one cell. You want all the duplicate numbers placed in that one cell?
What do you mean by "no spaces"? No spaces where? HTH Otto
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create list of duplicated numbers 6
Extract duplicates from two list to another sheet 2
Name the range AFTER copied to new sheet 6
keep duplicated numbers, eliminate single occurances 1
Copy range if match 2
sort duplicates in string 2
Line count in sheet determines paste range in another sheet 1
Consolidate (sum) last sheet (32) of all workbooks in a folder 15

Top