Where are all the Customers? How to use Excel to Find Where Most of your Customers are Located

        KEY POINTS

It's important to know where the majority of your customer base is located in order to make smart marketing decisions.  

• This video post uses your customer table to sum up the total number of customers in each state and then we use conditional formatting to show the top 3 states holding the largest number of customers.

• This type of information can be extremely important in determining why some salesman within certain regions or state are more successful than others and can act as a prelude in reviewing your customer demographics to focus efforts into regions and areas that are truly looking for your product.

• Note - all data used in this post was randomly generated and contains no real customer information (including addresses, phone numbers or company names).