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