Hey, I'm not sure the best way to go about this I have been experimenting with IF and Vlookup but I have failed to come up with an elegant solution (or an even remotely functional one)
Details:
Column A contains colors, some of which contain duplicates.
Column B contains descriptions of the column A, some of which are blank
Goal: I would like all unique colors in column A to have their previously listed descriptions auto-populate in column B or a new column and if the latest color is a new one something like "Actionable" to appear.
Example (Also attached in excel file)
Colors Taste
Red Lame
Blue
Red
Blue Smells
Green Good
Yellow
Yellow Great
White Okay
Blue
Red
Black
Bookmarks