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
Space at end of multi page list to accommodate new entries 1
Find duplicated values and paste range results on next sheet - nextavailable row 0
Combo box 0
Help needed! Extracting Heading 3 and Contents from a Word Doc to Excel 0
Formating bolded text exclusively. 0
Name the range AFTER copied to new sheet 6
Extract name, address and ph# 8

Top