Particular text count based on condition

[nur2544]

Dear all, I am having new challenge, need to solve macro or formula solution. Here is my input data in the cell A & cell B.

Please Login or Register  to view this content.

need output like below in the output sheet start from cell C,D,E

Please Login or Register  to view this content.

please check the attachment

[martindwilson]

Please Login or Register  to view this content.

see attached

[nur2544]

Hi martindwilson , Thanks for your repay, it works well. but i will be more happy if any macro solution is there , as my first part of the project already done by macro.

[martindwilson]

need to solve macro or formula solution

well that fulfils your original request!

[nur2544]

Hi martindwilson , here my data range is not fixed (i have given 10 data as an example ), sometime data range 65536 or some time 10,00000. so if data range is big
then it takes lots of time to complete the whole output.
please not that your solution is ok , & i am planing to use it , but for slowness , i am seeking for speeding way. i mean macro solution