Hi. Wi fi and hotspot are not possible so I hope that without a sample attachment I could still get a solution to this problem.
Column A consists of values that are duplicated more than once, but the duplicates are contiguous to each other.
Column B consists of other sets of values.
I would like a formula in column C that returns Y if Column B has 1 or 2 . The Y should start from the first row of the sets of duplicated values in Col A.
Example:
A B C
C Y
C 2 Y
C Y
D
D
G Y
G 1 Y
G 1 Y
G Y
Thank you. I cannot properly align the values, all Y should be in Col C.