Hi,
I am breaking my head to find an formulae to solve this and I am unable to figure out. Can someone please help me.
I have an report that has an entry sheet where the employees enter the loan numbers that they have worked on in column "C" then the borrower name in "D" Loan validation (Pass or Fail) in G. columns H to Q have failed items that refers to a code like 19-B, 3-A which basically says (19) means which document had error and (B) means what was the error. like name in application form etc.
the loan number has 10 digits, the first 3 digits refer to the branch code where they are originated. Branches are gouped together as Teams so we have team 100, 200 and 300, with each team having 50 branches each branch has a unique 3 digit code that will be the first 3 digit of the loan number.
my manager aksed me to map the entry sheet to another sheet in suach a way that it should reflect total number of loan processed for each Team (100, 200 and 300 seperatley), and then it should also show how many loans failed the validation for each Team. He also wants me to show the total number of errors for each team.
I am realy not sure how will I add multiple numbers (branch codes) and then count the total. I am unable to find a solution for all three above requirements. Any help is really appriciated.
Thanks
Jaya
Bookmarks