Excel Magic Trick 1189

Extract Color From Description Create Revenue by Color PivotTable, 2nd Take

DESCRIPTION

See how extract color from description, but only when the color is a single word with a space before and after the word. Great formula from Leonid Koyfman at YouTube using LOOKUP and SEARCH function and concatenated spaces.




Be the first to comment

Leave a Reply