Mar 08 2020 08:26 AM
Hello,
I have a list of product descriptions (Column A) that contain the color and product type. I'm trying to separate the color into another column (Column C) so that I can sort by Design # (Column B) and then Color (Column C). I have a separate list of possible colors I would like to use to search with (Column E).
Any ideas on what to use for a formula?
Thank you for any suggestions :)
Mar 08 2020 08:46 AM
@rg1008 Attached something based on what I recently created in another topic in this forum. I believe it will work for you. Just make sure you enter your colours in the "keyword"-list (Named Range) in the correct order. Enter all the variations first, then just the "single colour". Have a look at the file and you'll understand.
Let me know if you need more help.
May 04 2021 04:39 AM