ExcelBanter - Extract Duplicates to create another list.

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Extract Duplicates to create another list. (https://www.excelbanter.com/excel-programming/425527-extract-duplicates-create-another-list.html)

J.W. Aldridge

Extract Duplicates to create another list.

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).

Otto Moehrbach[_2_]

Extract Duplicates to create another list.

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
"J.W. Aldridge" wrote in message
...
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).

All times are GMT +1. The time now is 12:08 PM.