Update a Column based on multiple column values in Excel VBA

[Wazz]

Hi All,

I have been given a data set in Excel which is consist of 20k+ rows.
The data is for the past six months' SLA for 3000+ processes.

Within the last 3 months, I need to identify the processes which have failed to meet their SLAs. Based on the below, the raw with the latest month needs to be updated with a comment (a new column should get updated).

If all 3 months' SLA are Not Met - Comment is "3M"
If any of the 2 months' SLAs are Not Met - Comment is "2M"

I first tried a function, but it takes ages to process and then my file is crashing.
I haven't tried any Macros yet as I'm very new to this. I checked about 50+ results from googling, but none of them helped me.

SLA Name is on Column A
Month is on Column B
Met/ Not Met is on Column C
I need the comment on Column D

Pardon my Grammar and I'd really appreciate your help which would immensely save my time.

 

[Wazz]

Hi All,

I have been given a data set in Excel which is consist of 20k+ rows.
The data is for the past six months' SLA for 3000+ processes.

Within the last 3 months, I need to identify the processes which have failed to meet their SLAs. Based on the below, the raw with the latest month needs to be updated with a comment (a new column should get updated).

If all 3 months' SLA are Not Met - Comment is "3M"
If any of the 2 months' SLAs are Not Met - Comment is "2M"

I first tried a function, but it takes ages to process and then my file is crashing.
I haven't tried any Macros yet as I'm very new to this. I checked about 50+ results from googling, but none of them helped me.

SLA Name is on Column A
Month is on Column B
Met/ Not Met is on Column C
I need the comment on Column D

Pardon my Grammar and I'd really appreciate your help which would immensely save my time.

This is how the Database will look like - I have filtered a few rows and updated the comment manually

 

[airforceone]

a sample data in xl2bb format is much appreciated and would love to see your code