Key Word through Filter Search

Hi Folks,

I was hoping you could assist me with a question that I was asked.

There is a key word bank (attachment 3) that represents an issue found in a certain legal case.

The question proposed to me is this:

Can you have a look at how to quickly locate cases by keyword, when more than one keyword applies? Current problem is that keywords don’t break out separately when more than one applies to a case.

Capture.PNG

Capture1.PNG

Capture2.PNG

Thank you very much,

We can't do much with a picture of your data (better to attach an Excel workbook), but perhaps you can use a helper column to identify records where any keywords are found, such as with a COUNTIF formula like this:

=IF(COUNTIF(keyword_list,"*"&case_keyword&"*")>1,"Yes","No")

and copy this down to the bottom of your data, where keyword_list is the range that contains your keywords, and case_keyword is the cell in each row that contains the descriptions you are looking for.

Then you can filter that column to pick out those records where 2 or more keywords occur.

Hope this helps.

Pete

Any other suggestions or thoughts? I have attached the excel spread sheet in a duplicate post.