Hi,
Please refer to the attached file for more explanation ...
Here's some info before starting >>
For each style# (column A),there are multiple colors, and one of them has been selected as a feature color (column E). However, names of the feature colors (column B) sometimes REPEAT because they were available in both petites and avg sizes, for instance; in these cases, different color# (column D) have been assigned to distinguish them.
Here's what I was trying to do >>
I already indicated 'feature' color for each style#, but I didn't know that it was listed more than once for each style#. if you look at S200868313 WHITE (C5), for instance, it says 'feature' in E5 too, but another S200868313 WHITE exists in (C7), but it doesn't say 'feature in E7.
How can I do this besides using data filter to go and click every single style#-feature color out there?
Bookmarks