Question description:
This user has given permission to use the problem statement for this
blog.
Need to count a Specific text for specific name in a range
Solved by V. B. in 20 mins
This is the chat thread from the real Excelchat help session. It contains no private user
information.
Excelchat Expert
29/11/2017 - 04:09
Welcome to excel got it pro
Excelchat Expert
29/11/2017 - 04:09
I'm here to help you today.
User
29/11/2017 - 04:09
Hi
User
29/11/2017 - 04:09
Should I give the example?
Excelchat Expert
29/11/2017 - 04:10
sure. I need example.
User
29/11/2017 - 04:11
Now, I need to calculate, How many case Aman resolved
Excelchat Expert
29/11/2017 - 04:11
okay.
Excelchat Expert
29/11/2017 - 04:11
gimme a few minutes please.
User
29/11/2017 - 04:11
sure
User
29/11/2017 - 04:12
Is it free service?
Excelchat Expert
29/11/2017 - 04:13
ah, first session is free. You have to buy credit for subsequent sessions.
User
29/11/2017 - 04:13
ok
User
29/11/2017 - 04:14
So first session has 14 minutes remaining
Excelchat Expert
29/11/2017 - 04:15
yes, and option for an extend of further 20 mins if the question isn't resolved. But we won't need that much time. :)
User
29/11/2017 - 04:15
ok
User
29/11/2017 - 04:15
great
Excelchat Expert
29/11/2017 - 04:17
=countifs(B:B,"=Aman",C:C,"Resolved") now this will give you result for How many Aman has resolved.
Excelchat Expert
29/11/2017 - 04:17
We need to tweak it a little bit to get result for everybody else.
User
29/11/2017 - 04:18
ThaWhy B:B?
Excelchat Expert
29/11/2017 - 04:19
first it search column B and counts Aman in it. then search C for resolved. that's why B:B and C:C. B:B means entire column B.
Excelchat Expert
29/11/2017 - 04:19
does it make sense?
User
29/11/2017 - 04:20
Right. Can I try on my sheet
Excelchat Expert
29/11/2017 - 04:20
yes, please.
User
29/11/2017 - 04:23
It is working
User
29/11/2017 - 04:23
Thank you so much
Excelchat Expert
29/11/2017 - 04:23
my pleasure
User
29/11/2017 - 04:23
I shows my credit is 16
User
29/11/2017 - 04:24
Can I use next time or I have to buy now?
Excelchat Expert
29/11/2017 - 04:24
if after closing the session you still have 16 remaining credits then you can get a session otherwise you would have to buy new credits.
Excelchat Expert
29/11/2017 - 04:25
Pricing should be available in the dashboard or in our homepage
Excelchat Expert
29/11/2017 - 04:25
anything else you wanna know?
User
29/11/2017 - 04:26
Thank you so much Expert
Excelchat Expert
29/11/2017 - 04:26
My please
Excelchat Expert
29/11/2017 - 04:26
I would like to get feedback on my service.
Excelchat Expert
29/11/2017 - 04:26
Please rate me once you click on the "end session" button.
Excelchat Expert
29/11/2017 - 04:27
Have a great day! and don't forget to visit us if you fetch any kind of problem with excel.
Excelchat Expert
29/11/2017 - 04:27
:)
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.