VBA Count maximum occurance of a value in a row

[pratheekp]

I need to write a macro that searches a specified column and counts all the cells that contain a specified string, such as character "p" and character "q" then associate this in another column specifying how many occurrence of "p" and how many occurrence of "q" in a different column.
Have attached a sample screen shot of the same.
Does anyone have any ideas?

https://imgur.com/8wa1u4w

The total column indicates the character which has occurred maximum number of times in pair1,pair2,pair3 and pair4

Thank you in advance.

 

[slpswhite]

Instead of a Macro could you use the COUNTIF feature for your columns and than total them in your final column?