I'm doing a list of Top 60 Agents in Crystal 2008 and I need to get rid of duplicates.  At the moment, the report will only sort identical company names together and count them.   Is there a way to sort 'like' but not identical company names/phrase together and count them as being the same thing.

For example, if a company name has been entered in 3 records in 3 different formats such as 'MacMillan Associates' 'MacMillan Assoc.' and 'MacMillan Ltd.', I need Crystal to count them as the same company, instead of 3 different companies.  This problem can refer to any number of different names on the list, so I'm not talking about looking for '*MacMillan*' and grouping it.

Thanks