how to reconcile multiple names for same customer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I receive a large spreadsheet that is a combination of reports from multiple
distributors. Each distributor lists customers with slightly different
names, and then their total sales to that customer.

Example customer names:

Danaher, Danaher Industrial, Danaher Chemical, Danaher industries, etc. I'd
like to automatically sum the sales to all of the *Danaher*.

How do I go about?
 
This is why customer numbers were invented.

However, it you have no choice but to use the name, you can work with Sumif, as
in:

=sumif(A:A,"*danaher*",B:B)
 
Back
Top