09-26-2012 06:50 AM
I have a data base (11,000+ contacts) that was given to me to do some work on..first question was ..."tell me how many companies are in the database" seems easy enough, but I can't figure out how to do this. Listing "Companies" only presents company entires that do not have any contact names >>
Any help woul dbe appreciated!
09-26-2012 07:06 AM
If you go to the company view there will be a number in the bar at the bottom of the page for the number of companies in the database. If however you want to know the number of different companies listed in the company field in the contact record the way I would do it is export the contact list to Excel and then get a unique list of the contents of the company column. There is a function in Excel to let you do that.
09-26-2012 11:22 AM
It's finding the unique companies that makes it a little tricky. If you just want the contacts that have a company listed you can do a lookup on the company field with the operation "Contains Data".