I have a spreadsheet that has a list of my customers' addresses, including fields for ZIP code and the name of the location of the store where they made their purchase. I would like to create a separate sheet that lists the following:
-- The ZIP codes of my customers
-- The total number of customers from each ZIP code
-- The number of customers from each ZIP code for each store location
I know I can accomplish this manually by filtering results by ZIP and store, but is there a way to do this automatically with a formula?
Thanks.
Bookmarks