Question description:
This user has given permission to use the problem statement for this
blog.
I need a formula written into cells (AI8 to EK8) to identify patterns and then count specific data. sheet name: SHOPEE PATTERNS ONE ROW have data of different shooter (wins and losses from cells B to H) that I need identify. There were 2 rows (AI4:EK4 and AI2:EK2) that will determine which cells to count and which to keep blank after applying the formula.
Solved by V. J. in 60 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
User
22/05/2018 - 07:37
hello!
Excelchat Expert
22/05/2018 - 07:37
Welcome, Thanks for choosing Got It Pro-Excel.
User
22/05/2018 - 07:38
please tell me quickly whether it can be done
Excelchat Expert
22/05/2018 - 07:38
Okay.
Excelchat Expert
22/05/2018 - 07:38
Do you have sample data that we can work on?
User
22/05/2018 - 07:38
last advisor was unable to provide any help in this
User
22/05/2018 - 07:38
yes
Excelchat Expert
22/05/2018 - 07:39
Provide it please...
User
22/05/2018 - 07:39
excel link
User
22/05/2018 - 07:39
https://drive.google.com/file/d/14tOI0P2fTFVaKbAbnZJ4O-7PqV-ALSM3/view?usp=sharing
User
22/05/2018 - 07:40
Doc file for better and clear understanding (Just read page 1)
User
22/05/2018 - 07:40
https://docs.google.com/document/d/1fBWLYxGAECcTn5AsOoYBVrbSKq1ZaA9Sht6ZNANnUfI/edit?usp=sharing
Excelchat Expert
22/05/2018 - 07:41
Okay.
Excelchat Expert
22/05/2018 - 07:41
Just a moment as I go through this please.
User
22/05/2018 - 07:52
understood the woek?
User
22/05/2018 - 07:52
*work
Excelchat Expert
22/05/2018 - 07:53
This is the first time I am encountering this; so it needs more time....
Excelchat Expert
22/05/2018 - 07:53
I am still following...
User
22/05/2018 - 07:54
ok
User
22/05/2018 - 08:04
any progress?
Excelchat Expert
22/05/2018 - 08:05
It can be done.
Excelchat Expert
22/05/2018 - 08:06
It will need more time than the one which we are assigned.
User
22/05/2018 - 08:06
ok what should, I do then?
Excelchat Expert
22/05/2018 - 08:07
I wish I had more time so that I can give a perfect solution for you on this.
User
22/05/2018 - 08:07
I can buy the plan. can I cancelled it anytime
Excelchat Expert
22/05/2018 - 08:08
Yeah you can.
User
22/05/2018 - 08:08
ok tell me how you are planning to achieve it
User
22/05/2018 - 08:08
ok great
User
22/05/2018 - 08:10
I can see there is free trial for unlimited session for a week
User
22/05/2018 - 08:10
I am usning it if not satified I will cnacek it straight away
User
22/05/2018 - 08:11
Please give me your advisor id or something, so that we can resume this session
User
22/05/2018 - 08:12
there?
Excelchat Expert
22/05/2018 - 08:12
I am working on the solution.
User
22/05/2018 - 08:15
ok, please provide your expert ID. if chat ends we can resum the work
User
22/05/2018 - 08:16
or else I have to start again with the new person
User
22/05/2018 - 08:25
there?
User
22/05/2018 - 08:27
update me
User
22/05/2018 - 08:36
I guess you too unable to resolve this
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.