05-26-2010 06:42 AM
05-26-2010 05:52 PM
I've read this a few times and am not quite sure what you want to do. It sounds like you want to look up either the 97 contacts with that string in it or you want to look up the "Companies" that have contacts with that string in it.
My first question is at what point is "Campaign 0001" entered? It is entered into a contact screen or in a "Companies" screen. It is my understanding that the linked process is a one to many and not a many to many or many to one.
My first gut is to do a lookup on the contacts with the data and then export them to Excel taking advantage of pivot tables focused on the company name.
I've seen some pretty creative answers on this board, so hopefully someone will jump in with a different approach.
05-27-2010 04:57 AM