I have a spreadsheet that is taking entirely too much time to massage the data. In one column in the branch office number, in another is the type of account and in the third is a reason code. I need to have a count by branch office of every account code by reason code. For instance, Branch 3 has 36 RS accounts and of the 36 the count by each reason code. I can use SUMIFS but it is getting complicated that way. I can't use sort the data because I need to go to another report.
Any ideas? Maybe I just want this to be easier than it can be.
Branch Reason Type
3 O VC
1 1 VC
1 O RS
1 M RS
3 M CC
1 D RS
1 N AC
1 L RS
1 D QS
1 D RS
1 1 AC
1 L RS
Bookmarks