VBA match and add comment macro amendment

Hi, I have a macro, which I would like to amend slightly. Right now, it's lopping through column P and providing comments in column T, IF:

1. Same value exists more than once
2. There's a specific value in column next to P.

I would like the macro to do the same procedure, but provide comments in column T, only if in column P there are also cells with other values than those in my code.

So for instance if in column P:

1. Same value occurs multiple times
2. It's value in column P equals to either "Triggered" or "Periodic"
3. AND there's the other string in column P for the same value
4. There's a comment in column T.

Please Login or Register  to view this content.

Many thanks for your help.

Originally Posted by bizzarofen

... in column P there are also cells with other values than those in my code.

So for instance if in column P:

1. Same value occurs multiple times
2. It's value in column P equals to either "Triggered" or "Periodic"
3. AND there's the other string in column P for the same value
4. There's a comment in column T.

Your references to "value" and "values" are vague. Are values in some column other than P being examined?
What does "AND there's the other string in column P for the same value" mean?

Hi sintek, I am attaching a sample workbook with my data.

@leelnich - Sorry for the confusion, I indeed explained it badly, so let me explain in more detail. Macro is based on values in column P and column I. With regards to your second question - macro is at first looking for duplicates in column P and then based on the values in column P, it's adding a comment in column T.
I would like to slightly improve the macro so it will work like this:


1. Same value occurs multiple times in column P
2. AND value in column I equals to either "Triggered" or "Periodic"
3. AND there's also the other string in column I
4. Add a comment in column T.

Hope I managed to explained it better now.

Attaching the file.

String, which is different than "Periodic" or "Triggered"

In that case. Ideally, macro will include also other statuses if I were to add some.

I think we're on the same page here, so just to put it in more detail:

If the same value occurs multiple times in column P
And If Column I contains either "Periodic, Triggered" AND in the same time there are also other string than "Periodic, Triggered" in column I for the same multiple values in column P then Put 'Published" in Column T?

It'll be perfect if this comment will be added for the matched rows, but there might be also marking rows in different color, in case that's easier to be amended.

This should do

Please Login or Register  to view this content.

Hi jindon, many thanks for your help, this macro is just astonishing. Will it be possible to add " Non-published" comment in col T in a situation when there is a match , but the values are not "Triggered", "Periodic"?

Not really sure though...

Please Login or Register  to view this content.

Or this

Please Login or Register  to view this content.

Thank you so much jindon, that's just perfect!