"GGI Mark" wrote in message
...
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.

Data - Filter - Advanced Filter and mark Unique Records to hide duplicated
company names
then in a blank cell, =subtotal(2,range) to count the remaining
visible rows.