I receive this format file every working day. It has multiple rows and columns. I want to calculate monthly average of num created, num actioned, percentage completed, overdue < 5 days, => 5 days, of each of the sub component loans, deposits, auth overdrafts, unauth overdrafts, cash etc. for each market and platform. I want the average every month. Struggling with 30 sheets now.
