I need a formula written into cells to identify patterns and then count specific data. The pattern data that first needs to be identified is spread across column B through I. The formula should first recognize the pattern within these cells. THEN according to the search criteria, the formula should match one of three values and produce a value of either (1) or -(7). I have a video that explains my needs in detail. Please watch video first before accepting tasks. The Sheets labeled 'SHOOPEE PATTERNS ONE ROW' and 'SHOOPEE KEY' are the active worksheets within the file attached that need the formulas pertaining to this project.
Please download explanation video from this link [login to view URL]
62 freelancers are bidding on average $132 for this job
Hello. I have rich experiences in Excel and good skills in VBA. I have read your project description carefully and i can do it. I hope your kind contact. Best regards.
Dear Sir/Madam, Please consider my offer for this project. The video link is not valid anymore, but i am confident i can complete this project for 1 day. BR, Stoyan