Excel Magic Trick 1186

Extract Color From Description Field & Create Revenue by Color PivotTable

DESCRIPTION

See how:
(00:09) Problem Setup
(01:04) Barry Houdini at Mr Excel Message Board and pmsocho at YouTube
(01:23) SEARCH function with a Function Argument Array Operation to create array with position of color information
(02:38) LOOKUP and SEARCH function to lookup color name
(04:19) PivotTable to create Revenue by Color Report




Be the first to comment

Leave a Reply