Hello Excel Guru's !
I have an excel spreadsheet which contains a list of free text descriptions.
What I would like to achieve, is for excel to read these free text fields and if it finds certain predefined keywords, that it should assign them to a certain category.
I thought my excel knowledge was okay, but I'm not really sure where to start with this - The logic behind it seems fairly straight forward but I am not even sure if this is achievable using excel so I thought I'd ask the experts!
I have attached a stripped down sample, which just contains the data for this problem.
Very briefly;
if it reads the Sheet1/Job Title column and finds any of the keywords from Data/category keywords, then it should assign the appropriate category
I hope that my description makes sense!
Many thanks for reading
I have an excel spreadsheet which contains a list of free text descriptions.
What I would like to achieve, is for excel to read these free text fields and if it finds certain predefined keywords, that it should assign them to a certain category.
I thought my excel knowledge was okay, but I'm not really sure where to start with this - The logic behind it seems fairly straight forward but I am not even sure if this is achievable using excel so I thought I'd ask the experts!
I have attached a stripped down sample, which just contains the data for this problem.
Very briefly;
if it reads the Sheet1/Job Title column and finds any of the keywords from Data/category keywords, then it should assign the appropriate category
I hope that my description makes sense!
Many thanks for reading