Hi All,I am manually tagging the colors (plan code) to each following corresponding date with colors already for FINAL tagging, problem is for example if i encountered a date with 2 or 3 different colors i have to choose the dominant color for its FINAL color tag. I've been doing the tagging manually and was hoping if someone could help formulate a formula to make things easier for my task as i am doing this by thousands of dates tagging them manually took huge amount of time and consumes a lot of energy haha, attached here is the screenshot of the scenario of what i am currently doing. really appreciate any help i could get. Capture.JPG
Bookmarks