Counting unique values in one column, based on criteria determined by another column
Apologies for replicating any similar posts, but I have read through many and not understood how to apply the solutions given.To make things easier I have uploaded a sample file which is a substantially reduced version of my excel with some sample data.
The basic goal of this is to establish how many unique customers we have placing orders at any given time through each financial year so that we can say for example; by January in the financial year of 2012 we had 100 orders from 50 unique customers, however in January of financial year 2012 we only had 150 orders from 70 unique customers.
The single worksheet has 4 columns of data plus a small table that I wish to populate. I want to populate the table based on the following:
- For each month of the given financial year, with each year being a new row, I wish to count how many customers in that month placed their first order for that financial year. Therefore, at the end of the table I should be able to sum the months of that year to give me the total number of of customers who placed their first order that year.
- Each year should be treated individually, disregarding whether a customer placed an order in the prior year.
Does this make sense? Please ask me any questions and I will clarify if necessary.
Video Tutorials / Excel Dashboards Reports