I have two rows of data - Col A = Customer Number / Col B = Region, for each month of the year
I wish to look up two things -
1. Which customer numbers are reporting in Feb that also reported in Jan and count the different regions
2. Which customers are reporting Feb that did not report in Jan and count the regions
I wish to look up two things -
1. Which customer numbers are reporting in Feb that also reported in Jan and count the different regions
2. Which customers are reporting Feb that did not report in Jan and count the regions