LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1,071
Default 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).



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need to create a list of non-duplicates JRobertson New Users to Excel 1 January 13th 12 04:37 AM
Extract duplicates from two list to another sheet J.W. Aldridge Excel Programming 2 February 20th 09 07:49 PM
Create a separate list of duplicates Rob L Excel Discussion (Misc queries) 1 April 23rd 08 11:00 PM
How can I create a list of random numbers with no duplicates? Kwasniewski Excel Discussion (Misc queries) 2 May 15th 06 02:44 AM
extract list of names and elimanate duplicates Frank Kabel Excel Worksheet Functions 2 October 27th 04 04:52 PM


All times are GMT +1. The time now is 09:05 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"