Re: Counting unique values in one column, based on criteria determined by another col
I would add a helper column to determine all the first order customers for the year
so in E2 enter formula:
copied down. This will concatenate the month and financial year for easy counting later.
Then in G5:
copied across the months and down the years.
Hope that works for you.
Where there is a will there are many ways. Finding one that works for you is the challenge!
MS Excel MVP 2010-2016