| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Sorting customer names
I have a list of customer names that is over 6000 now and growing. I want to
extract the names that appear only once on this list. How do I accomplish this? There are header names "First, Last, Int, Address, City, State, Zip, Phone (2) and Vin". |
|
#2
|
|||
|
|||
|
This should help:
http://www.officearticles.com/excel/...ft_excel. htm ************ Anne Troy www.OfficeArticles.com "seeking improvment" <seeking wrote in message ... I have a list of customer names that is over 6000 now and growing. I want to extract the names that appear only once on this list. How do I accomplish this? There are header names "First, Last, Int, Address, City, State, Zip, Phone (2) and Vin". |
|
#3
|
|||
|
|||
|
Take a look at DataFilterAdvanced Filter, there is a copy unique box in
there. -- HTH Bob Phillips "seeking improvment" <seeking wrote in message ... I have a list of customer names that is over 6000 now and growing. I want to extract the names that appear only once on this list. How do I accomplish this? There are header names "First, Last, Int, Address, City, State, Zip, Phone (2) and Vin". |
|
#4
|
|||
|
|||
|
Bob,
Thank you for your help this will make things easier for me. Sorry for the delay in getting back to you. Thank you Candy "Bob Phillips" wrote: Take a look at DataFilterAdvanced Filter, there is a copy unique box in there. -- HTH Bob Phillips "seeking improvment" <seeking wrote in message ... I have a list of customer names that is over 6000 now and growing. I want to extract the names that appear only once on this list. How do I accomplish this? There are header names "First, Last, Int, Address, City, State, Zip, Phone (2) and Vin". |
|
#5
|
|||
|
|||
|
Anne,
Thank you very much for your reply. I apoligise for the delay in saying thank you. The link you posted had all the answers I have been searching for. You have no idea how happy this makes me. "Anne Troy" wrote: This should help: http://www.officearticles.com/excel/...ft_excel. htm ************ Anne Troy www.OfficeArticles.com "seeking improvment" <seeking wrote in message ... I have a list of customer names that is over 6000 now and growing. I want to extract the names that appear only once on this list. How do I accomplish this? There are header names "First, Last, Int, Address, City, State, Zip, Phone (2) and Vin". |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Enter a customer name in the invoice workbook when the names are . | Excel Worksheet Functions | |||
| sorting names alphabetically when names may start with numbers | Excel Discussion (Misc queries) | |||
| Sorting names in a range | Excel Worksheet Functions | |||
| Text manipulaion (summarizing customer records) Index function probably not good choice | Excel Discussion (Misc queries) | |||
| Sorting Customer | Excel Discussion (Misc queries) | |||
Linear Mode
