View Single Post
  #1   Report Post  
GGI Mark
 
Posts: n/a
Default Count # of Businesses

I have a simple spreadsheet that I have compiled using business
information. In this spreadsheet there are multiple businesses with multiple
employees. Can someone help with a formula that will give me the count of the
number of indivual business.

Example

Whicker Basket Inc John Smith
Whicker Basket Inc Sally Jones
Lollipop Corp. Joe brown
Lollipop Corp. Mark Johnson

There are 2 companies but 4 employees how do I count just the companies.