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
 
Top