Hi,
I apologize if I'm in the wrong section with this question. I have an accounting spreadsheet that tracks individual sales orders for an online store. I use a separate sheet for each month, and so the single file accounts for one year of all sales. I would like to create a second file with a table that allows me to filter our growing list of customers for marketing analysis. The customer list is needed to tabulate a monthly value for the following:
  • # of unique new customers each month (taking into account the accumulated list of all unique customers from all months before)
  • running tally next to customer's name showing how many separate orders each customer has made

The ultimate goal is to have a single table to organize each unique customer, from A-Z. I'm fairly inexperienced at excel. This may be an easy problem to solve. Can anyone point me in the right direction?

Thanks for any help!
mcg



Screen Shot 2014-02-03 at 10.01.41 PM.png