Hello,
I've been fighting this for weeks, I have a dataset that is entered manually. I'm using the =unique function to extract the unique values in the list, but I need "attach" manual data to what's extracted. In my attached example I have a list of colors that spans several rows and columns. Next to this I extract the unique colors and manually assign a color code. If the dataset changes or grows I need a way to automatically shift the color code to the correct row.
In my real spreadsheet there would be hundreds of rows and columns, and everything to the right of the dynamic list would need to track it's corresponding "color".
Bookmarks