Question description:
This user has given permission to use the problem statement for this
blog.
Repost
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 S. H. in 9 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
25/05/2018 - 06:14
Hi
Excelchat Expert
25/05/2018 - 06:14
Welcome to Got it Pro
Excelchat Expert
25/05/2018 - 06:16
Are you there?
User
25/05/2018 - 06:16
hello!
Excelchat Expert
25/05/2018 - 06:16
Can you please elaborate on your requirement so that i can help better
Excelchat Expert
25/05/2018 - 06:16
Also is there some sample data that you can share
User
25/05/2018 - 06:16
Am I talking to the same expert? I have discussed the project ealier ?
Excelchat Expert
25/05/2018 - 06:17
No
User
25/05/2018 - 06:17
ah I guess not
Excelchat Expert
25/05/2018 - 06:17
I am talking to you for the first time
User
25/05/2018 - 06:17
thats not going to work
Excelchat Expert
25/05/2018 - 06:17
oh
Excelchat Expert
25/05/2018 - 06:17
If you tell me may be i can help you out
User
25/05/2018 - 06:18
its a big & complicated task, so 1 hour is not enough and dealing with new advisor everytime with no result is not going to help me
User
25/05/2018 - 06:18
its like I am running in circle
Excelchat Expert
25/05/2018 - 06:18
oh
Excelchat Expert
25/05/2018 - 06:18
What should i do now?
User
25/05/2018 - 06:19
let try but what if we are not able to finish it in 1 hour time
Excelchat Expert
25/05/2018 - 06:19
Do you want me to end it so that you can connect it to same user..you can also mention in your post so that same user picks up
Excelchat Expert
25/05/2018 - 06:20
What do you say?
User
25/05/2018 - 06:20
what should I mention?
User
25/05/2018 - 06:21
he asked me to use repost with the same description below and I have done it
Excelchat Expert
25/05/2018 - 06:21
Mention that the user to whom i connected earlier should pick up. others please dont pick it
Excelchat Expert
25/05/2018 - 06:21
Repost means any one else can pcik up..it means you had bad experience with previous user
User
25/05/2018 - 06:22
ok cool
User
25/05/2018 - 06:22
please end the chat
User
25/05/2018 - 06:22
thanks
Excelchat Expert
25/05/2018 - 06:22
I will end from my end but please do give good rating so that my rating is not affected
Excelchat Expert
25/05/2018 - 06:22
Hope you understand
User
25/05/2018 - 06:22
yes sure that not your fault :)
Excelchat Expert
25/05/2018 - 06:23
Thanks
User
25/05/2018 - 06:23
welcome!
Excelchat Expert
25/05/2018 - 06:23
Have a great day
User
25/05/2018 - 06:23
same to you
Excelchat Expert
25/05/2018 - 06:23
You can end from your end now
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.