**Question description:**

*This user has given permission to use the problem statement for this blog.*

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). 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.

Solved by E. D. in 60 mins

This is the chat thread from the real Excelchat help session. It contains no private user information.

Excelchat Expert
19/05/2018 - 06:25

Hello and welcome to Got it! :)

User
19/05/2018 - 06:25

hello!

User
19/05/2018 - 06:26

https://drive.google.com/file/d/14tOI0P2fTFVaKbAbnZJ4O-7PqV-ALSM3/view?usp=sharing

User
19/05/2018 - 06:26

I am unable to attached the file. I don't why I was getting the error

User
19/05/2018 - 06:26

so here is the link

Excelchat Expert
19/05/2018 - 06:27

It seems the file is too large for me to open online. However, I downloaded the file and will view it in the local Excel application. :)

User
19/05/2018 - 06:27

Thanks :)

User
19/05/2018 - 06:28

for better understanding one of my employee have created a video

User
19/05/2018 - 06:28

do you need that?

Excelchat Expert
19/05/2018 - 06:28

Wow, that would be nice if it could clearly explain the expectation in here. :)

User
19/05/2018 - 06:28

Great!

Excelchat Expert
19/05/2018 - 06:29

Oh, I've seen the file you've sent, and it includes VBA data, which is why it can't be uploaded in here.

Excelchat Expert
19/05/2018 - 06:30

We're actually limited to providing non-VBA solutions, and thus, VBA is outside our scope. However, we could look at how the concern can be addressed if there's a non-VBA way to do it.

User
19/05/2018 - 06:31

Yes, I need a non-VBA formula or any other best way

Excelchat Expert
19/05/2018 - 06:31

Okay, nice then. :)

User
19/05/2018 - 06:31

https://drive.google.com/file/d/1lVcdkO4gTeJN5izbgLJWb4MxYFVm2HEr/view?usp=sharing

User
19/05/2018 - 06:31

here is the video

Excelchat Expert
19/05/2018 - 06:38

Hi, I've watched the video, but it seems to have not mentioned what's supposed to be shown in the cells when the criteria is met. The video was cut off around 1min21sec.

User
19/05/2018 - 06:39

Can you please read my description? I hope that may help what I am looking for

User
19/05/2018 - 06:39

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). 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.

User
19/05/2018 - 06:40

Time is running out. what should I do?

User
19/05/2018 - 06:41

I am looking for another video. I guess there is one more video.

Excelchat Expert
19/05/2018 - 06:41

We could actually extend the session two times. We have a full hour to look into this. :)

User
19/05/2018 - 06:42

Thanks!

User
19/05/2018 - 06:42

Good to hear that :)

User
19/05/2018 - 06:43

was the description any help?

Excelchat Expert
19/05/2018 - 06:44

I'm a bit confused on this part: "THEN according to the search criteria, the formula should match one of three values and produce a value of either (1) or -(7)." If there's a pattern matching the criteria, what are the three values we're looking at here, and when does (1) or -(7) be displayed.

User
19/05/2018 - 06:45

let me look for the video then

User
19/05/2018 - 06:49

Sorry, I am unable to help you much with a query as I, not the one who was initially working on it but now I have to look inti it

Excelchat Expert
19/05/2018 - 06:51

Oh I see. I would really wish to help on this one, as I see it interesting to do. However, we really needed the three values with which we could match the formula on, and on what conditions will trigger a display of (1) or -(7). Is there any alternative to this or anything? :)

Excelchat Expert
19/05/2018 - 06:55

If someone initially worked with the Excel file, it would be best if that person can be contacted for information regarding this query. Or if there are turnover documents, maybe it's recorded in there our lacking information. :)

User
19/05/2018 - 06:56

https://drive.google.com/file/d/1iCDQUNgoZcbXlBDE1H-KDSCZ6rl6jcHQ/view?usp=sharing

User
19/05/2018 - 06:56

please check this video

User
19/05/2018 - 07:09

Are you there?

Excelchat Expert
19/05/2018 - 07:10

Yes I'm here. :)

Excelchat Expert
19/05/2018 - 07:10

I'm currently working on the SHOPEE PATTERNS ONE ROW. However, given our limited time, I may no longer be able to touch the SHOOPEE KEY. The video took time to download as it was pretty big and size.

User
19/05/2018 - 07:13

so are you clear about the work?

Excelchat Expert
19/05/2018 - 07:13

On the first one, I was able to grasp it.

User
19/05/2018 - 07:14

It can be done, right?

Excelchat Expert
19/05/2018 - 07:14

I believe so. I'm looking at it already.

User
19/05/2018 - 07:15

Great :)

User
19/05/2018 - 07:16

can we put the sheet online and continue the work there?

User
19/05/2018 - 07:16

I need to discuss the payment plan also. If this issue is resolved

Excelchat Expert
19/05/2018 - 07:17

Unfortunately, I've been trying to open the sheet online but can't seem to do it. I also wanted to work on it online, but somehow it can't open in google sheets.

User
19/05/2018 - 07:20

oh, can you get the solution and mail me the result?

User
19/05/2018 - 07:20

please

User
19/05/2018 - 07:23

there?

Excelchat Expert
19/05/2018 - 07:23

Yes, I'm currently doing the work. :)

User
19/05/2018 - 07:24

great!

Excelchat Expert
19/05/2018 - 07:24

Oh, unfortunately, we're bounded by the policy to communicate within this platform. :( So can't really communicate outside of Got it. I'm nearly done with the ONE ROW btw. :)

User
19/05/2018 - 07:24

ok

**This is the output file from the real Excelchat help session:**

*This is an example of the expert help you can get. It contains no private user information.*