Match and Count

[philb99]

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

 

[Peter_SSs]

I have two rows of data - Col A = Customer Number / Col B = Region,

That actually sounds like two columns of data.

Could we have a smallish set of dummy sample data and the expected results with XL2BB and explain again in relation to that sample data?

 

[philb99]

That actually sounds like two columns of data.

Could we have a smallish set of dummy sample data and the expected results with XL2BB and explain again in relation to that sample data?

Yes -sorry two columns

 

[Peter_SSs]

You need to actually select the range on your worksheet that you want to show on your worksheet before using XL2BB. Also, in most cases 'Mini Sheet' is better than 'Table Only' as it shows more information.

Further, please don't forget these parts ..

and the expected results with XL2BB and explain again in relation to that sample data?