Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
customer Name against Unique customer number count
I have a unique count of customer numbers (Z1 : Z100) now I want to get the
customer number associated to this number the customer names reside in B1:100) I can't use another Unique filter because sometimes the customers name is spelled in lower case or upper case or has "inc, corp" in it etc but is the same customer. what would I use? Thanks in advance -- Nelson |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
customer Name against Unique customer number count
Since there are only 100, I would sort them alphabetically, delete the
repeats. 100 should not be that bad ;-) If it were 10,000 might be another story. "Nelson" wrote in message ... I have a unique count of customer numbers (Z1 : Z100) now I want to get the customer number associated to this number the customer names reside in B1:100) I can't use another Unique filter because sometimes the customers name is spelled in lower case or upper case or has "inc, corp" in it etc but is the same customer. what would I use? Thanks in advance -- Nelson |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
customer Name against Unique customer number count
wont work, This is a template for another 6 tabs and growing each tab
contains lots of product data each tab needs to auto generate unique customer numbers counts and unique customers by product version. These numbers get rolled up to a summary page -- Nelson "Meebers" wrote: Since there are only 100, I would sort them alphabetically, delete the repeats. 100 should not be that bad ;-) If it were 10,000 might be another story. "Nelson" wrote in message ... I have a unique count of customer numbers (Z1 : Z100) now I want to get the customer number associated to this number the customer names reside in B1:100) I can't use another Unique filter because sometimes the customers name is spelled in lower case or upper case or has "inc, corp" in it etc but is the same customer. what would I use? Thanks in advance -- Nelson -- Nelson "Meebers" wrote: Since there are only 100, I would sort them alphabetically, delete the repeats. 100 should not be that bad ;-) If it were 10,000 might be another story. "Nelson" wrote in message ... I have a unique count of customer numbers (Z1 : Z100) now I want to get the customer number associated to this number the customer names reside in B1:100) I can't use another Unique filter because sometimes the customers name is spelled in lower case or upper case or has "inc, corp" in it etc but is the same customer. what would I use? Thanks in advance -- Nelson |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
customer Name against Unique customer number count
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Nelson" wrote in message ... I have a unique count of customer numbers (Z1 : Z100) now I want to get the customer number associated to this number the customer names reside in B1:100) I can't use another Unique filter because sometimes the customers name is spelled in lower case or upper case or has "inc, corp" in it etc but is the same customer. what would I use? Thanks in advance -- Nelson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Min Date againsts unique customer list | Excel Worksheet Functions | |||
HELP! Customer count issues... Pivot Table disaster | Excel Worksheet Functions | |||
CONVER CSV CUSTOMER DATA TO A CUSTOM INDIVI CUSTOMER PRICE SHEET | Excel Discussion (Misc queries) | |||
how do I advance filter a large csv file for unique customer #'s | Excel Worksheet Functions | |||
Count Duplicates Order numbers for one Customer | Excel Worksheet Functions |