Filter Data which only contains specific word

[zqlcancer]

Below is an example of my data. My request is to filter the data which cell only includes word "ok"(i.e. line 1,2,3). Is it possible?

Line	Remark
1	Ok
2	Ok/Ok
3	Ok/Ok/Ok
4	Ok/tax is wrong/ok
5	Tax not included

[PhilipMannering · Accepted solution]

What about a custom filter with expression,

REGEX_Match([Remark], '(ok/?)+')

[zqlcancer]

@PhilipMannering , thanks for reply, it worked. Is it possible to explain your expression? especially why do you use the bracket, plus sign and question mark？

[PhilipMannering]

Sure.

The ? means 0 or 1 of the preceding character. So /? matches a forward slash or no forward slash

The + means 1 or more. Since the stuff before is in brackets, it's 1 or more of "ok" or "ok/"

[HenriHiebert88]

Yes, it's possible. You can use a filter function or conditional formatting in Excel to filter or highlight the cells that contain only the word "Ok".

[zqlcancer]

@PhilipMannering ，thanks for your reply. It helps a lot.