Dear all,


I would like to request, if it is possible to create a macro following the logic and example explained below:


“count how many times specific variable (i.e "JPM", "BAML", "DM") in column C has occurred for the following strings ("ABS", "CMBS", "CLO") in column D"

The input and output of sample data can be seen in the attachment below:

Deals_count.xlsm


Any help and guidance to this problem would be very much appreciated.

Thank you for your time and help in advance.

Kind regards
Misbah