I have an excel file with a list of customer names in column A and a list of dates for every transaction they've made in a given year in column B. I would like to find a way to manipulate this data so that I can determine if there are customers who have only shopped between 4/1 and 6/30 of a given year, versus those customers who are shopping throughout the entire year.
Ultimately this means I would like to end up with two subgroups: those people who shop throughout the year, and those people who only shop during the April-June timeframe. I'm not sure they best way to approach this, so any help would be greatly appreciated!
Ultimately this means I would like to end up with two subgroups: those people who shop throughout the year, and those people who only shop during the April-June timeframe. I'm not sure they best way to approach this, so any help would be greatly appreciated!
