I attached two excel file one is rib and another is bank statement. In rib file there are four column date, cash, cheque, bc, total. In total u find that there is repetitoin of amount like rs 1962 is 14 times. and same amount 13 times in bank statement. i want to give these amount id. like i show in rib file. same process happen in bank statement after giving the id to amounts in rib and bank statements file. we have to give to id to all amount although they repeted once or more. then we have to match the total culumn of rib with total of bank statment have conidtion that the date of bank statment is equal or higher and total amount and id matched with rib total and id.
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.