how to reconcile multiple names for same customer
 

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?

how to reconcile multiple names for same customer
 

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)

--
Regards,
Fred


"charlenegrelli" wrote in message
...
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?