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]
63 pekerja bebas membida secara purata $131 untuk pekerjaan ini
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.