Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
find names on list 1 in list 2. list 1 4000 names list 2 400 name | Excel Worksheet Functions | |||
Update master list with other lists | Excel Worksheet Functions | |||
data validation list drop down text format too small | Excel Worksheet Functions | |||
Attaching labels when using large or small functions | Excel Worksheet Functions | |||
Font too small in Incell drop down list | Excel Worksheet Functions |