Couldn't you use the custom filter and show rows where col F "contains" Rich?

"Dave" wrote:

I have a spreadsheet which has filters at the top.

In column A there are lists of activities. Sometimes there are multiple
assigned to an activity. To explain it simply, for example:

Col A Col F (Person assigned)
Activity 1 Rich
Activity 2 Dan, Rich
Activity 3 Rich, Dan

I want to be able to sort and list all activities that Rich is involved in
but the filter can only do all Dan, Rich and then all Rich somewhere else etc.

Can I do this using filters and can you also suggest a worksheet function to
do this e.g. using the match funtion?

Thanks!

David