Count # of Businesses

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
With the companies listed in Column A, try this:

=SUMPRODUCT((A1:A30<>"")/COUNTIF(A1:A30,A1:A30&""))

--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
GGI Mark said:
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.
Click to expand...

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.
 
Back
Top