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.
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.