Fill Column based on Specific data from another Column
Hi All,
Flash fill has been playing up a bit on this column, I am trying to create a Formula to allow excel to check what colour is in ROW F and then Put that colour into ROW D. There is around 128,000 products.
I am having issues with flash fill because some of the fields have Black + Honeycomb Filter and flash fill just puts in “Filter” which isnt a colour. Or Instead of putting Anodic Bronze Matt it just puts “Matt”
Is there a Formula that can do this ?
Happy to make a table with all the colours etc….
Thanks !
Hi All, Flash fill has been playing up a bit on this column, I am trying to create a Formula to allow excel to check what colour is in ROW F and then Put that colour into ROW D. There is around 128,000 products. I am having issues with flash fill because some of the fields have Black + Honeycomb Filter and flash fill just puts in “Filter” which isnt a colour. Or Instead of putting Anodic Bronze Matt it just puts “Matt” Is there a Formula that can do this ? Happy to make a table with all the colours etc…. Thanks ! Read More