Compare two column's values

[LEXCERM]

Hello and a Happy New Year!

Example:
I have two columns of data [ColA] and [ColB]. For one instance of a value in [ColA] (A, B, C, E, F, H), then these will be defined as "Good" ([Result] column).

For multiple letters (D, G), I then need to look at values in [ColB]:-
- If the value is the same, i.e. D has one value both of which are 2, then all of D's values will be "Good".
- If there is a difference in the values, i.e. G has values 3 and 4, then all of G's values will be defined as "Not Good".

I have sorted the columns accordingly.

Either a formula or VBA will be good.

Many thanks in advance.

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF(COUNTIFS(A:A,A2,B:B,"<>"&B2),"Not good","Good")

 

[LEXCERM]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

How about

=IF(COUNTIFS(A:A,A2,B:B,"<>"&B2),"Not good","Good")

Many thanks for this! It works.... don't know why, just yet..... but it works!

Have also updated my Account details.

All the best.

 

[Fluff]

You're welcome & thanks for the feedback.