Hi all,
I have data in column BY which has multiple values across rows. Many of these values might repeat themselves, 2, 3, 4....no limit to how many times. There are values in column F, which have the either of the two markings "E" or "F".
My requirements is to go through column BY, look for repeating values, and if even any one of those repeating values have the marking F for them, then all these repeating values should get the words "YES" written beside them in column BZ else, they should have "NO".
For e.g. if the value XYZ repeats in column BY at rows 2,3 & 4, and column F, row 3 has a marking "F" and the other two rows have the markings "E", all three of these rows should have the words "YES" in column BZ. Any formula or VBA macro which can help me out with this is greatly appreciated, as I have been at it for quite some time now but not getting a solution. Thank you in advance.
I have data in column BY which has multiple values across rows. Many of these values might repeat themselves, 2, 3, 4....no limit to how many times. There are values in column F, which have the either of the two markings "E" or "F".
My requirements is to go through column BY, look for repeating values, and if even any one of those repeating values have the marking F for them, then all these repeating values should get the words "YES" written beside them in column BZ else, they should have "NO".
For e.g. if the value XYZ repeats in column BY at rows 2,3 & 4, and column F, row 3 has a marking "F" and the other two rows have the markings "E", all three of these rows should have the words "YES" in column BZ. Any formula or VBA macro which can help me out with this is greatly appreciated, as I have been at it for quite some time now but not getting a solution. Thank you in advance.