Download the featured file here: www.bluepecant...
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.
------------------------
Негізгі бет Excel Lookup and Find the 2nd, 3rd, 4th or Nth Occurrence / Match (Without Using an Array Formula)
Пікірлер: 28