VBA code to count specific values

**missy22** · 11-21-2012, 07:26 AM

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

**[email protected]** · 11-21-2012, 08:10 AM

Hi,

Do you really need macro for this...? looks like this can be done with countifs.

Please check the attached sheet.

**missy22** · 11-21-2012, 08:25 AM

Dear all,

I would like the output to be displayed in "Sheet2", but I cannot get the formula below to work:

Please Login or Register  to view this content.

If possible, can this formula be covnerted into VBA code?

Thank you for your help and time.

**missy22** · 11-27-2012, 08:25 AM

Could anyone please provide any assistant/help to the above post.

Thank you in advance

**Jacc** · 11-27-2012, 09:57 AM

Just mark the yellow field, select Cut and paste it on Sheet2.

**missy22** · 12-04-2012, 07:56 AM

Dear all,

I have updated data, however the formula below does no seem to picking up correct count values in Sheet4 (please attachment).

Please Login or Register  to view this content.

The sample workbook shows:
Count_formula_updated.xls

Sheet 1 --> input data source

Sheet 4 --> output table with formula

The highlighted row in Sheet4, shows one of many values which has not picked up all the count.

I am not sure why the formula is not picking up accurate count values for specific values .

Any help would be very much appreciated.

Thank you for your time and help.

**Jacc** · 02-20-2013, 12:58 PM

It's really a shame that posts like these just flow down the stream without anyone noticing. Well defined problem, polite threadstarter...

By now it's probably too late but hey...

There was an error in that some of the cells containing ABS RMBS CLO CDO CMBS was preceded by a space. The cells that the formula uses as reference that is.

As long as it wasn't first in the cell in the datarange it would pick it up but if it was first it was not preceded by a space and would not be counted.