3 ms·
Pivot tables can help there. If you pivot on color, you will more easily see that lone "grey" between the "gray"'s. You can also copy-paste-as-values a known-g
by Someone 11y ago
Pivot tables can help there. If you pivot on color, you will more easily see that lone "grey" between the "gray"'s.
You can also copy-paste-as-values a known-good one, and compare what you have know against what you had last week.
And of course, you can enforce an enumeration in Excel. See https://support.office.com/en-us/article/Apply-data-validation-to-cells-c743a24a-bc48-41f1-bd92-95b6aeeb73c9 https://support.office.com/en-us/article/Apply-data-validati...