amit_gupta123
Member
Hii.. I have a query similar to query I have asked earlier. I have a workbook containing sheet "present date " in which customerId & payment made to the parties are mentioned.There are various daywise sheets also in which payments are made by customers to various parties on different days. The party names are not exactly matching as data operater entring the name manually. Now in sheet present date i want to match that how many times a Cutomer ID makes a pyament to same party. I used sumproduct formula for searching 25 days but it's taking much time as my data for each day is around 3000. please suggest any code or formula Sample sheet is attached herewith