Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 3rd 06, 05:02 PM posted to microsoft.public.excel.misc
Howie J.
 
Posts: n/a
Default remove small list from large list

I have two mail lists on excel. The first has 16,000 names, the second has
about 6,000. I need to remove the 6,000 from the 16,000 as they all appear
in the big list as well. How do I extract those 6,000 entries from the larger
list? My expected result is a mailing list with 10,000 names.

  #2   Report Post  
Old January 3rd 06, 05:46 PM posted to microsoft.public.excel.misc
Dave Peterson
 
Posts: n/a
Default remove small list from large list

Chip Pearson has some techniques at:
http://www.cpearson.com/excel/duplicat.htm

Howie J. wrote:

I have two mail lists on excel. The first has 16,000 names, the second has
about 6,000. I need to remove the 6,000 from the 16,000 as they all appear
in the big list as well. How do I extract those 6,000 entries from the larger
list? My expected result is a mailing list with 10,000 names.


--

Dave Peterson
  #3   Report Post  
Old January 4th 06, 10:37 PM posted to microsoft.public.excel.misc
Howie J.
 
Posts: n/a
Default remove small list from large list

Thanks Dave, it was a bit over my head but I finally figured it out.

"Dave Peterson" wrote:

Chip Pearson has some techniques at:
http://www.cpearson.com/excel/duplicat.htm

Howie J. wrote:

I have two mail lists on excel. The first has 16,000 names, the second has
about 6,000. I need to remove the 6,000 from the 16,000 as they all appear
in the big list as well. How do I extract those 6,000 entries from the larger
list? My expected result is a mailing list with 10,000 names.


--

Dave Peterson



Reply
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
find names on list 1 in list 2. list 1 4000 names list 2 400 name Ed Excel Worksheet Functions 1 September 4th 05 12:48 AM
Update master list with other lists Chab Excel Worksheet Functions 0 August 4th 05 03:46 PM
data validation list drop down text format too small Bruce Edwards Excel Worksheet Functions 3 May 22nd 05 07:28 PM
Attaching labels when using large or small functions BobT Excel Worksheet Functions 1 February 18th 05 11:03 PM
Font too small in Incell drop down list Keith Excel Worksheet Functions 2 January 12th 05 02:44 PM


All times are GMT +1. The time now is 07:22 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017