Notifications
Clear all
Topic starter
Hi, in the attached file which is just an example - in column A there are answers I received to the questionnaire.
In the report on the side I need him to look for the word Cousult
in a column and count how many times it is written.
I will note that the word counsel is written within a sentence.
How do you do it??
In my work file there are 20 comments and I can't search them manually one by one..
Thank you very much...
Posted : 21/06/2023 7:10 pm
Here is a Macro solution for Consult which you can adapt for your other counts
Option ExplicitSub Lea()Dim i As Long, lr As Long, x As Longlr = Range("A" & Rows.Count).End(xlUp).Rowx = 0For i = 2 To lrIf InStr(Range("A" & i), "consult") > 0 Thenx = x + 1End IfNext iRange("C3") = xEnd Sub
Posted : 21/06/2023 11:02 pm
Topic starter
Thanks!!!
I need the answer to many cells in the report on the side.
So I would love to understand how to activate the macro and how to get the answer in all the cells. Thanks!!!!
And it is not possible to write this in a normal function in Excel? Why do you need a macro code?
If you could send me the answer in the file, it would help me a lot, thanks!!!
Posted : 21/06/2023 11:07 pm
