Download the featured file here: https://www.bluepecantraining.com/wp...
In this video I demonstrate how to categorise text values based on a list of keywords.
I have a list of course names. If the course name contains words like Excel or Outlook, I want to categorise the course as a Microsoft course. If the course name contains words like InDesign or Premier, I want to categorise the course as an Adobe course.
The functions featured in this video tutorial are SEARCH, MATCH and INDEX.