Extract Duplicates to create another list.

  • Thread starter Thread starter J.W. Aldridge
  • Start date Start date
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).
 
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
Copy range to different columns depending on cell value 1
Extract duplicates from two list to another sheet 2
InputBox to name a range 2
keep duplicated numbers, eliminate single occurances 1
Name the range AFTER copied to new sheet 6
Extraction 3
sort duplicates in string 2

Back
Top